commit d000681f719c0e638e97135f90b435ea05785c5c
author hdeist hdeist <hdeist@google.com> Fri Oct 08 13:11:15 2021 -0700
committer hdeist hdeist <hdeist@google.com> Fri Oct 08 13:11:15 2021 -0700
tree a266e9b268953ec7591109113b4f0846febcdc8a
parent 1eea4c5350fc773edc57facb66531f546e5f4690

segment2

Change-Id: Ib74fcf799e3e88895b7dea1a7c8b36a1edcc198a

views/revenue_pdt.view.lkml

diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
index f5a9cab..165617b 100644
--- a/views/revenue_pdt.view.lkml
+++ b/views/revenue_pdt.view.lkml
@@ -4,7 +4,9 @@
   derived_table: {
     sql: SELECT
         'foo' as foo,
-        segment
+        segment,
+        segment segment2,
+        format_timestamp('%F %T', current_timestamp(), 'America/Los_Angeles') pdt_time_bis
       FROM gcc_internal.revenue
       ;;
     sql_trigger_value: SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP());;
@@ -21,11 +23,16 @@
   dimension: segment {
     type: string
     sql: ${TABLE}.segment ;;
-
   }
+
+  dimension: segment2 {
+    type: string
+    sql: ${TABLE}.segment2 ;;
+  }
+
   dimension: pdt_time {
     type: string
-    sql: format_timestamp('%F %T', current_timestamp(), 'America/Los_Angeles') ;;
+    sql: ${TABLE}.pdt_time_bis ;;
 
   }
 #