bozo Change-Id: I6350cc3363bc4860c2471e2529d9bb7e1b5eebfb
diff --git a/hdeist-fdm.model.lkml b/hdeist-fdm.model.lkml index 52e5a0a..a55a752 100644 --- a/hdeist-fdm.model.lkml +++ b/hdeist-fdm.model.lkml
@@ -1,9 +1,12 @@ connection: "concord" +# bozo include: "/*.view" datagroup: hdeist_fdm_default_datagroup { max_cache_age: "1 hour" } persist_with: hdeist_fdm_default_datagroup + +explore: uli_view {}
diff --git a/uli_view.view.lkml b/uli_view.view.lkml new file mode 100644 index 0000000..6754673 --- /dev/null +++ b/uli_view.view.lkml
@@ -0,0 +1,26 @@ + + +view: uli_view { + sql_table_name: `irvine-sbx.fdm.uli` ;; + + dimension: partition_date { + type: string + sql: ${TABLE}.partition_date ;; + } + + dimension: service_id { + type: string + sql: ${TABLE}.service_id ;; + } + + dimension: usage_date { + type: date + datatype: date + sql: ${TABLE}.usage_date ;; + } + + measure: count { + type: count + } + +}