segment2 Change-Id: Ib74fcf799e3e88895b7dea1a7c8b36a1edcc198a
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 ;; } #