a Change-Id: Ife41a5a02c35857d3e0174d2b8e9340383924cca
diff --git a/http_testing.model.lkml b/http_testing.model.lkml new file mode 100644 index 0000000..c23290a --- /dev/null +++ b/http_testing.model.lkml
@@ -0,0 +1,20 @@ +connection: "l4c_testing" # bare repo + +include: "test.view.lkml" # include all views in the views/ folder in this project +# include: "/**/*.view.lkml" # include all views in this project +# include: "my_dashboard.dashboard.lookml" # include a LookML dashboard called my_dashboard + +# # Select the views that should be a part of this model, +# # and define the joins that connect them together. +# +# explore: order_items { +# join: orders { +# relationship: many_to_one +# sql_on: ${orders.id} = ${order_items.order_id} ;; +# } +# +# join: users { +# relationship: many_to_one +# sql_on: ${users.id} = ${orders.user_id} ;; +# } +# }
diff --git a/test.view.lkml b/test.view.lkml index 85b1ad9..1c7f356 100644 --- a/test.view.lkml +++ b/test.view.lkml
@@ -1,69 +1 @@ -view: test { - # # You can specify the table name if it's different from the view name: - # sql_table_name: my_schema_name.tester ;; - # - # # 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} ;; - # } -} - -# view: test { -# # 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} ;; -# } -# } +view: test { }