Set up the Databricks Connector for Google Sheets
This feature is in Public Preview.
To use the Databricks Connector for Google Sheets, you must first connect to your Databricks workspace and select a SQL warehouse. This page describes how to set up the initial connection and how to switch to a different workspace.
Before you begin
- Create a Databricks workspace. See Create a workspace.
- Create a Databricks SQL warehouse. See Create a SQL warehouse.
- Have access to Google Sheets.
- Install the Databricks Connector for Google Sheets.
- If your Databricks workspace has IP access lists enabled, the account admin must add the Google Cloud IP list to the allow list.
- To learn more about IP access lists, see Configure IP access lists for the account console.
- For the Google Cloud IP list, see this IP list.
Connect to Databricks workspace
After installing the Databricks Connector for Google Sheets, import data from Databricks into Google Sheets by connecting to a Databricks workspace:
-
In the Google Sheets menu bar, click Extensions > Databricks Connector > Launch sidebar to open the connector.
-
In the Login dialog, enter your Databricks workspace URL. To learn how to find your workspace URL, see Get identifiers for workspace objects.
- Your workspace URL is in the following format:
https://<instance-name>.cloud.databricks.com.
- Your workspace URL is in the following format:
-
Click Sign in.
-
A dialog prompts you to sign in or shows your login status.
-
After logging in, select which SQL warehouse to use. In the Databricks Connector sidebar, under the Data tab, choose a Databricks SQL warehouse by clicking the circle in the upper right of the connector sidebar and selecting your preferred Databricks SQL warehouse. The connector starts the chosen SQL warehouse.
Change Databricks workspace
To change the Databricks workspace you are connected to:
- Select Extensions > Databricks Connector > Change workspace.
- Enter the new workspace URL and authenticate to the workspace.