This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

BigQuery - automation

Posted on 03-01-2024 08:22 AM
logan_branson
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi,

In my project the data lands in bigquery via an Alteryx workflow. Afterwards the bigquery tables are transformed using SQL and the transformed tables are written to back BigQuery from where it is fed to dashboard.

Now I want to automate and schedule these BigQuery SQL scripts to run on the 5th day of every month. Can we do this using just BigQuery? Or would we need any other tool as well? Please suggest the same.

Thanks

PS: There are 4-5 sql scripts that runs in succession, so there is a dependency

0 3 3,067
Topic Labels
0 Likes
3 REPLIES 3