Schedule data refreshes in Google Sheets

Important

This feature is in Public Preview.

This page describes how to schedule automatic data refreshes in the Databricks Connector for Google Sheets to keep your imported data up to date. Scheduled refreshes run your saved queries on a recurring basis and update the corresponding sheets.

Requirements

• You have set up the Databricks Connector for Google Sheets and imported data from Azure Databricks.

Create a Unity Catalog connection

A metastore admin must first create the connection in Google Sheets and grant access to users who want to create scheduled refreshes in Google Sheets. Scheduled refreshes require a connection called databricks_google_connection in Unity Catalog.

1. As a Azure Databricks metastore admin, in Google Sheets, launch the Databricks Connector for Google Sheets sidebar.
2. Click the Imports tab.
3. Click the calendar in the upper-right side.
4. Click Setup connection.
5. Users with the MANAGE privilege on a connection must grant the USE CONNECTION privilege to users who want to create or manage scheduled refreshes. For more on managing connections, see Manage connections for Lakehouse Federation.

Create a schedule

Each import can be assigned to only one schedule. To create a new schedule for an existing import:

1. In the Azure Databricks connector sidebar in Google Sheets, click the Imports tab.

2. Click the calendar icon and click New Schedule.

3. Select which import to create a schedule for.

4. Enter a name for the schedule.

5. Select the Frequency of your schedule:

   • For Hourly, select which minute of the hour to run the refresh.
   • For Daily, select the time of day to run the refresh.
   • For Weekly, select the day of the week and the time to run the refresh.

   The schedule uses your local time zone.

6. Select the SQL warehouse to use for the scheduled queries.

7. Click Create schedule.

Manage schedules

To view or delete your scheduled refreshes, do the following:

1. In the Azure Databricks connector sidebar in Google Sheets, click the Imports tab.
2. Click the calendar icon and click Manage schedules.
3. Select a schedule to view schedule details, including the included queries and schedule configuration.
   • If you are viewing a schedule created by someone else, the time shown is the time in the creator's local time zone.
   • To delete a schedule, click Delete.

Limitations

• You can't edit a scheduled refresh. You can only view or delete existing schedules. To modify a schedule, delete it and create a new one.
• If you edit a query that is included in a schedule, you must delete the schedule and recreate it with the updated query so that the schedule uses the updated query text.
• You can't schedule a refresh on pivot tables. The Google API only updates the raw query data and cannot modify the pivot configuration if the query result schema changes.