Connect to Databricks from Google Sheets

Preview

This feature is in Public Preview.

This page describes how to use the Databricks Connector for Google Sheets to connect to Databricks from Google Sheets. The Databricks add-on enables you to query Databricks data from within Google Sheets, allowing you to conduct further analysis.

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.
  • To see the Google Cloud IP list, see this list.

Connect from Google Sheets

This section describes how to pull data from Databricks into Google Sheets using the Databricks Connector for Google Sheets.

1. In Google Sheets, select Extensions > Databricks Connector > Launch sidebar to open the connector.

   

2. On the Login dialog, enter your Databricks workspace URL. To learn how to find your workspace URL, see Get identifiers for workspace objects.

3. Click Sign in.

4. A dialog will either prompt you to sign in to your Databricks account or show that you have logged in.

5. On the Databricks Connector sidebar, select a SQL warehouse to use.

6. Enter your SQL query.

   

7. In Google Sheets, select the cell where you want query results to start.

8. Click Run.

9. Google Sheets populates with the query results, starting from the selected cell.