Setting Up the Schedule for Automatic Data Refreshes

BigQuery Reports (Google Sheets Extension) allows you to schedule the data refreshes in your reports.

 

Step 1. Open your Google Sheet document, which is built with OWOX BI BigQuery Reports extension.

Step 2. In the extension panel, open the 'Scheduled Refresh,' block and click the 'Open schedule settings' button.

Screenshot 2024-05-30 at 19.05.23.png

Or, you can open this window from the toolbar. Go to 'Extensions' → 'OWOX BI BigQuery Reports' → 'Scheduled refresh.'

Step 3. In the opened window, Enable reports to run automatically by clicking on the checkbox.

06.png

Step 4. Specify the refresh frequency and the following options.

IMPORTANTThe schedule will be based on the timezone specified in the document settings. If, for any reason, the timezone cannot be retrieved, the schedule will default to UTC (GMT +0). How to change the time zone

Let's look at the example below for Hourly updates:

_scheduling-2024-hourly.gif

Below is an example for Daily updates:

_scheduling-2024-daily.gif

An example for Weekly updates:

_scheduling-2024-weekly.gif

And finally, look at the example for Monthly updates:

_scheduling-2024-monthly.gif

Step 5. Select a list of reports, which will be updated.

Step 6. If you wish to receive notifications about data refreshes in the report, check the 'Send notifications to...' box. Next, choose your preference for email notifications: opt for receiving all notifications or only those in the case of errors.

Step 7. Confirm that you understand and agree with Google BigQuery pricing policy.

Step 8. Click the 'Save' button.

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.