a Change-Id: I12ef34a9b82a53cd5ba08410ba46679d84f425c2
diff --git a/new_model.model.lkml b/new_model.model.lkml deleted file mode 100644 index 1ed042e..0000000 --- a/new_model.model.lkml +++ /dev/null
@@ -1,3 +0,0 @@ -connection: "l4c_testing" - -persist_for: "0 seconds"
diff --git a/testing.view.lkml b/testing.view.lkml new file mode 100644 index 0000000..344e83f --- /dev/null +++ b/testing.view.lkml
@@ -0,0 +1,37 @@ +######################## +# Purpose: L4C Testing +# Author: Data Team +# Date: 05/24/2021 +####################### + +view: testing { + + derived_table: { + sql: + SELECT 200 AS value, CURRENT_TIMESTAMP() AS time + UNION ALL + SELECT 100 AS value, CURRENT_TIMESTAMP() AS time + ;; + } + + dimension: value_raw { + hidden: yes + type: yesno + sql: ${TABLE}.value ;; + } + + dimension_group: time { + hidden: yes + datatype: timestamp + type: time + sql: ${TABLE}.time ;; + } + + + measure: value { + type: sum + sql: ${value_raw} ;; + + } + +}
diff --git a/testing_model.model.lkml b/testing_model.model.lkml new file mode 100644 index 0000000..261f0ef --- /dev/null +++ b/testing_model.model.lkml
@@ -0,0 +1,7 @@ +connection: "l4c_testing" + +persist_for: "0 seconds" + +include: "testing.view.lkml" + +explore: testing {}