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