commit d2f2cb8055b3cc7c944083f00c742562f4ad1927
author last laff <hdeist@google.com> Wed Aug 25 21:37:48 2021 -0700
committer last laff <hdeist@google.com> Wed Aug 25 21:37:48 2021 -0700
tree 6ce979168c1e39621b65ee48c2f2b7ccce876b41
parent d94753aac4bbc2f21b640247bf87c38c29de9f75

create derived table view pru based on view imported from hdeist-fdm

Change-Id: I05703ee73b8675415c36ae4699729d1012f8b7ef

hdeist-pdt.model.lkml

diff --git a/hdeist-pdt.model.lkml b/hdeist-pdt.model.lkml
index 669feb4..61cebad 100644
--- a/hdeist-pdt.model.lkml
+++ b/hdeist-pdt.model.lkml
@@ -1,12 +1,13 @@
 connection: "fdm_pdt"
 
 include: "/*.view"
+include: "//hdeist-fdm/uli_explore.explore"
 datagroup: pdt_datagroup {
   max_cache_age: "1 hour"
 }
 
 persist_with: pdt_datagroup
 
-explore: uli_view2 {}
-
 explore: pru {}
+
+explore: uli_view2 {}

manifest.lkml

diff --git a/manifest.lkml b/manifest.lkml
new file mode 100644
index 0000000..a9677a8
--- /dev/null
+++ b/manifest.lkml
@@ -0,0 +1,7 @@
+
+
+project_name: "hdeist-pdt"
+
+local_dependency: {
+  project: "hdeist-fdm"
+}

pru.view.lkml

diff --git a/pru.view.lkml b/pru.view.lkml
index 190dcd8..6e676f6 100644
--- a/pru.view.lkml
+++ b/pru.view.lkml
@@ -1,12 +1,29 @@
+include: "//hdeist-fdm/uli_explore.explore"
+
 view: pru {
   derived_table : {
-    explore_source: uli_view2 {
+    explore_source: uli_view {
       column: partition_date {
-        field: uli_view2.partition_date
+        field: uli_view.partition_date
       }
       column: usage_date {
-        field: uli_view2.usage_date
+        field: uli_view.usage_date
+      }
+      column: zork {
+        field: uli_view.zork
       }
     }
   }
+  dimension: partition_date {
+    type: string
+    sql: ${TABLE}.partition_date ;;
+  }
+dimension: usage_date {
+  type: string
+  sql: ${TABLE}.usage_date ;;
+}
+dimension: zork {
+  type: string
+  sql: ${TABLE}.zork ;;
+}
 }

uli_view2.view.lkml

diff --git a/uli_view2.view.lkml b/uli_view2.view.lkml
index 43064cf..18d6d1f 100644
--- a/uli_view2.view.lkml
+++ b/uli_view2.view.lkml
@@ -19,6 +19,10 @@
     sql: ${TABLE}.usage_date ;;
   }
 
+  dimension: magoo {
+    type: string
+    sql:  'magoo' ;;
+  }
   measure: count {
     type: count
   }