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