In big query, i have an export of search console data landing into a table daily, this is done by Google and can happen at any time of the day. I then run a query to enrich and format the data into another table for use in Data Studio.
I’d like to know the best way to trigger the query everytime this table is updated.
Scheduled queries do work, but there is some uncertainty/no fallback if the daily export didn’t land in time. ideally when the data lands in the raw dataset, it would then trigger the job to run?
New contributor
Rik is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.