Just an updated version of the one I shared in my presentation "Store, Extract, Transform, Load, Visualize" in Madrid Nov 2016
Deze collectie tonen
Simplest way to schedule #BigQuery jobs. GSheet > http://goo.gl/fmxmNf
Sends Success/Fail email
1 Copy the sheet
2 Update the query and the details of the table to append results
3 Go to Tools > Script Editor
4 Create trigger for the day/time you want the query to run
Enjoy!
-
-
Bedankt, Twitter gebruikt dit om je tijdlijn te verbeteren. Ongedaan makenOngedaan maken
-
-
-
How does the email notification work exactly. Will it email if the job fails to be submitted, fails during execution or both?
-
During execution. Couldn't find better way than getJobId() and getState() every few secs. Does the trick but I was lazy enough not to use getErrors() to go report better what's the issue when they happen. Check the code there.
Einde van gesprek
Nieuw gesprek -
-
-
I linked your BigQuery automation Google sheet from this new
#worldcup2018 post ("Visualizing all the goals"). Thanks for sharing!https://medium.freecodecamp.org/world-cup-all-the-goals-in-2018-b52e5ef53e0a … -
Cool, thanks Felipe!
Einde van gesprek
Nieuw gesprek -
Het laden lijkt wat langer te duren.
Twitter is mogelijk overbelast of ondervindt een tijdelijke onderbreking. Probeer het opnieuw of bekijk de Twitter-status voor meer informatie.