create fdm_uli explore
Change-Id: I7f1c0f119f9ceefac6bbf0ad00bb6bf61a476882
diff --git a/fdm_uli.view.lkml b/fdm_uli.view.lkml
new file mode 100644
index 0000000..3a579cc
--- /dev/null
+++ b/fdm_uli.view.lkml
@@ -0,0 +1,30 @@
+view: fdm_uli {
+ derived_table: {
+ sql: select partition_date, service_id, account_id from `irvine-sbx.fdm.uli`
+ ;;
+ }
+
+ measure: count {
+ type: count
+ drill_fields: [detail*]
+ }
+
+ dimension: partition_date {
+ type: string
+ sql: ${TABLE}.partition_date ;;
+ }
+
+ dimension: service_id {
+ type: string
+ sql: ${TABLE}.service_id ;;
+ }
+
+ dimension: account_id {
+ type: string
+ sql: ${TABLE}.account_id ;;
+ }
+
+ set: detail {
+ fields: [partition_date, service_id, account_id]
+ }
+}
diff --git a/hdeist-fdm.model.lkml b/hdeist-fdm.model.lkml
new file mode 100644
index 0000000..b5f54cb
--- /dev/null
+++ b/hdeist-fdm.model.lkml
@@ -0,0 +1,20 @@
+connection: "concord"
+
+include: "/*.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: fdm_uli {}
+# 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} ;;
+# }
+# }
