init hdeist-fdm
diff --git a/models/hdeist-fdm.model.lmkl b/models/hdeist-fdm.model.lmkl
new file mode 100644
index 0000000..a0b5fcb
--- /dev/null
+++ b/models/hdeist-fdm.model.lmkl
@@ -0,0 +1,11 @@
+connection: "concord"
+
+include: "/*.view"
+datagroup: hdeist_fdm_default_datagroup {
+ # sql_trigger: SELECT MAX(id) FROM etl_log;;
+ max_cache_age: "1 hour"
+}
+
+persist_with: hdeist_fdm_default_datagroup
+
+explore: sql_runner_query {}
diff --git a/sql_runner_query.view.lkml b/sql_runner_query.view.lkml
new file mode 100644
index 0000000..e797737
--- /dev/null
+++ b/sql_runner_query.view.lkml
@@ -0,0 +1,26 @@
+view: sql_runner_query {
+ derived_table: {
+ sql: select service_id , usage_date from `irvine-sbx.fdm.uli`
+ ;;
+ }
+
+ measure: count {
+ type: count
+ drill_fields: [detail*]
+ }
+
+ dimension: service_id {
+ type: string
+ sql: ${TABLE}.service_id ;;
+ }
+
+ dimension: usage_date {
+ type: date
+ datatype: date
+ sql: ${TABLE}.usage_date ;;
+ }
+
+ set: detail {
+ fields: [service_id, usage_date]
+ }
+}