Knowledge Drop

BIGQUERY (HowTo): PDT Trigger Value for Business Hours (Specific Hours) Rebuild only


Userlevel 3
Badge

Last tested: Sep 10, 2019
 

What to use for a sql_trigger_value to cause an hourly rebuild but only during the day (7am to 7 pm in database time) for BigQuery.
 

SELECT IF(EXTRACT(HOUR FROM CURRENT_DATETIME()) BETWEEN 7 AND 19,

EXTRACT(HOUR FROM CURRENT_DATETIME()), 0)

 

 

This content is subject to limited support.                

 

 

 


0 replies

Be the first to reply!

Reply