create derived table view pru based on view imported from hdeist-fdm Change-Id: I05703ee73b8675415c36ae4699729d1012f8b7ef
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 {}
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" +}
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 ;; +} }
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 }