View the original community article here
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)