commit 9c2ce737241787e8da1177b5befebe99f986658a
author hdeist hdeist <hdeist@google.com> Mon Oct 11 08:53:23 2021 -0700
committer hdeist hdeist <hdeist@google.com> Mon Oct 11 08:53:23 2021 -0700
tree f9b17205e494e2603e385a468d81be45fec8211a
parent 7063e560629643ead2a84c36a51466de38ad5dc0

enable pdt

Change-Id: Ie103db2fe0760274ff27fc00405ee3688c2bbca9

views/revenue_pdt.view.lkml

diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
index dff0fa4..6bfb6ac 100644
--- a/views/revenue_pdt.view.lkml
+++ b/views/revenue_pdt.view.lkml
@@ -9,8 +9,8 @@
         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());;
-  #   publish_as_db_view: yes
+  sql_trigger_value: SELECT concat('pdt_trigger hour is', EXTRACT(HOUR FROM CURRENT_TIMESTAMP()));;
+    publish_as_db_view: yes
   }
 #
 #   # Define your dimensions and measures here, like this: