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