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} ;; -# } -# }