Cervinodata can automatically generate scheduled queries per organisation in Google BigQuery.
The purpose of these scheduled queries is to have flat tables with reporting data for each organisation available, so reporting in Looker Studio per organisation is made as easy as possible, without any coding and without the need for blending.
First Cervinodata will generate a dataset for each organisation. And after that a list of default template queries is used to generate scheduled queries per organisation in Google BigQuery.
The Cervinodata web interface will display the list of scheduled queries and enables you to turn the queries on or off.
To be able to use this feature at least one scheduled query must be created in Google BigQuery, in the project that is used by Cervinodata. And this query needs to created by the Google user that was used to give consent to Cervinodata to synchronise the data to Google BigQuery.
Also the scheduled query option will need to be enabled in Cervinodata.
Please contact support if you want to enable the scheduled query option in Cervinodata.