Connecting to Databricks

Connecting to Databricks from Excel

To connect to Databricks from Excel, you will need to use the Databricks ODBC driver. We have pre-configured the Databricks ODBC driver for you to use.

To load a table from Databricks into Excel, follow these steps:

1. Open Excel
2. Click on the Data tab
3. Click on Get Data
4. Click on From other sources
5. Click on From ODBC
6. Select the Databricks DAL ODBC driver from the list of available drivers
7. Click OK
8. Click on the Windows tab as we have single sign-on enabled
9. Ensure that the Use my current credentials radio button is checked
10. Click Connect
11. You will be presented with a list of schemas and tables in Databricks. Select the schema and table you want to import into Excel.

If you are familiar with SQL, you can also write a SQL query to import data from Databricks into Excel. It is recomended that you write your sql in the Databricks sql interface and then copy it into the excel interface. In the Databricks sql interface there is an AI assistant that can help you write your sql queries, no experience needed.

1. Open Excel
2. Click on the Data tab
3. Click on Get Data
4. Click on From other sources
5. Click on From ODBC
6. Select the Databricks DAL ODBC driver from the list of available drivers
7. Click Advanced options
8. Enter your SQL query in the SQL statement box
9. Click OK and your data will be imported into Excel

Connecting to Databricks from Power BI

Connecting to Databricks from Spotfire

1. Click Data in the menu
2. Select Manage Data Connections