create derived table pru
Change-Id: I9755efb9b0e481e185b0c520798349854629da68
diff --git a/hdeist-pdt.model.lkml b/hdeist-pdt.model.lkml
index 388ed00..669feb4 100644
--- a/hdeist-pdt.model.lkml
+++ b/hdeist-pdt.model.lkml
@@ -1,10 +1,12 @@
connection: "fdm_pdt"
-# include: "/*.view"
+include: "/*.view"
datagroup: pdt_datagroup {
max_cache_age: "1 hour"
}
persist_with: pdt_datagroup
-# explore: uli_view {}
+explore: uli_view2 {}
+
+explore: pru {}
diff --git a/pru.view.lkml b/pru.view.lkml
new file mode 100644
index 0000000..190dcd8
--- /dev/null
+++ b/pru.view.lkml
@@ -0,0 +1,12 @@
+view: pru {
+ derived_table : {
+ explore_source: uli_view2 {
+ column: partition_date {
+ field: uli_view2.partition_date
+ }
+ column: usage_date {
+ field: uli_view2.usage_date
+ }
+ }
+ }
+}
diff --git a/uli_view2.view.lkml b/uli_view2.view.lkml
new file mode 100644
index 0000000..43064cf
--- /dev/null
+++ b/uli_view2.view.lkml
@@ -0,0 +1,26 @@
+
+
+view: uli_view2 {
+ 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
+ }
+
+}
