create fdm_uli explore

Change-Id: I7f1c0f119f9ceefac6bbf0ad00bb6bf61a476882

fdm_uli.view.lkml

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]
+  }
+}

hdeist-fdm.model.lkml

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