2

I would like to automatically export the results of a Google BigQuery query to an S3 bucket every night. Does BigQuery support any kind of automated query runs?

This is kind of the reverse of this question.

Improve this question

1 Answer 1

Reset to default
1

BigQuery does not support any automatic scheduling of jobs. You would have to use some other framework to run some script on a schedule to insert the query job.

One such option might be a Google Apps Script time-driven simple trigger. BigQuery is accessible through Google Apps Script, so putting these together should get you the ability to run BigQuery jobs on a schedule.

Google Apps Script Simple Trigger options: https://developers.google.com/apps-script/guides/triggers/#available_types_of_triggers

BigQuery Google Apps script sample code: https://developers.google.com/apps-script/advanced/bigquery

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.