Do you recoil in horror at the thought of running yet another mundane SQL script just so a table is automatically rebuilt for you each day in BigQuery? Can you barely remember your name first thing in the morning, let alone remember to click “Run Query” so that your boss gets the latest data refreshed in his fancy Data Studio charts, and then takes all the credit for your hard work?
Well, fear not my fellow BigQuery’ians. There’s a solution to this madness.
Yes, it’s Google Apps Script to the rescue.
Disclaimer: all credit for this goes to the one and only Felipe Hoffa. He ‘da man!