add table to uli.view
Change-Id: Ib210641a1988049c246913303fdc8df2108082e6
diff --git a/views/uli.view.lkml b/views/uli.view.lkml
index c765f54..77a97f8 100644
--- a/views/uli.view.lkml
+++ b/views/uli.view.lkml
@@ -1,69 +1,11 @@
view: uli {
# # You can specify the table name if it's different from the view name:
- # sql_table_name: my_schema_name.tester ;;
+ sql_table_name: `irvine-sbx.fdm.uli` ;;
#
# # Define your dimensions and measures here, like this:
- # dimension: user_id {
- # description: "Unique ID for each user that has ordered"
- # type: number
- # sql: ${TABLE}.user_id ;;
- # }
- #
- # dimension: lifetime_orders {
- # description: "The total number of orders for each user"
- # type: number
- # sql: ${TABLE}.lifetime_orders ;;
- # }
- #
- # dimension_group: most_recent_purchase {
- # description: "The date when each user last ordered"
- # type: time
- # timeframes: [date, week, month, year]
- # sql: ${TABLE}.most_recent_purchase_at ;;
- # }
- #
- # measure: total_lifetime_orders {
- # description: "Use this for counting lifetime orders across many users"
- # type: sum
- # sql: ${lifetime_orders} ;;
- # }
+ dimension: partition_date {
+ label: "partition_date"
+ type: string
+ sql: ${TABLE}.partition_date ;;
+ }
}
-
-# view: uli {
-# # Or, you could make this view a derived table, like this:
-# derived_table: {
-# sql: SELECT
-# user_id as user_id
-# , COUNT(*) as lifetime_orders
-# , MAX(orders.created_at) as most_recent_purchase_at
-# FROM orders
-# GROUP BY user_id
-# ;;
-# }
-#
-# # Define your dimensions and measures here, like this:
-# dimension: user_id {
-# description: "Unique ID for each user that has ordered"
-# type: number
-# sql: ${TABLE}.user_id ;;
-# }
-#
-# dimension: lifetime_orders {
-# description: "The total number of orders for each user"
-# type: number
-# sql: ${TABLE}.lifetime_orders ;;
-# }
-#
-# dimension_group: most_recent_purchase {
-# description: "The date when each user last ordered"
-# type: time
-# timeframes: [date, week, month, year]
-# sql: ${TABLE}.most_recent_purchase_at ;;
-# }
-#
-# measure: total_lifetime_orders {
-# description: "Use this for counting lifetime orders across many users"
-# type: sum
-# sql: ${lifetime_orders} ;;
-# }
-# }
