CODEWITHSUNDEEP
google-bigquery
Han Chris
Han Chris

Reputation: 37

Custom Scheduled Query in Google BigQuery using timezone

I'm using scheduled query in Google BigQuery, The requirement is to set it every 1st month at 04:00 (UTC+7) (Indonesia Time)

I've tried custom scheduled query but since the timezone is in UTC, so I can not achieve my requirement.

Sample :

1st day of month 04:00 enter image description here

How to solve this? Can we set specific timezone in custom scheduled query in Google BigQuery?

Thanks

Upvotes: 1

Views: 1109

Answers (1)

kiran mathew
kiran mathew

Reputation: 2353

You can schedule your query based on your local time. For your requirements follow below steps:

Step 1: Write your query in the BigQuery console.

enter image description here

Step 2: Click the schedule button present at the top and select the option Create new schedule query

enter image description here

Step 3: Below the heading schedule options select the Repeatsoption as monthly from the drop down button and select the start at set time option radio button.

enter image description here

Step 4: Now click on the calendar icon to select the country and timezone.

enter image description here

Step 5: select Indonesia time zone as per your requirement and set the date and time.

enter image description here

Step 6: Fill all the required fields and click the save button.

Upvotes: 1

Related Questions