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

[rducarrouge]

Knowledge Drop

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)