Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
This feature is in Public Preview.
This page describes how to use the Azure Databricks Connector for Google Sheets to connect to Azure 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 an Azure Databricks workspace. See Create a workspace.
- Create an Azure Databricks SQL warehouse. See Create a SQL warehouse.
- Have access to Google Sheets.
- Install the Azure 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 Azure Databricks into Google Sheets using the Databricks Connector for Google Sheets.
In Google Sheets, select Extensions > Databricks Connector > Launch sidebar to open the connector.
On the Login dialog, enter your Databricks workspace URL. To learn how to find your workspace URL, see Get identifiers for workspace objects.
Click Sign in.
A dialog will either prompt you to sign in to your Databricks account or show that you have logged in.
On the Databricks Connector sidebar, select a SQL warehouse to use.
Enter your SQL query.
In Google Sheets, select the cell where you want query results to start.
Click Run.
Google Sheets populates with the query results, starting from the selected cell.
