Download and install the Databricks ODBC Driver

This article describes how to download and install the Databricks ODBC Driver.

Review the JDBC ODBC driver license before you download and install the ODBC driver.

Some tools and clients require you to install the ODBC driver before you can set up a connection to Azure Databricks, while others embed the ODBC driver and do not require separate installation. For example, to use Tableau Desktop, the ODBC driver must be installed, while recent Power BI Desktop releases include the ODBC driver preinstalled and no further action is needed. If you do not need to download or install the ODBC driver, skip ahead to Next steps.

To download and install the ODBC driver, complete the following instructions, depending on your operating system:

• Download and install the ODBC driver for Windows
• Download and install the ODBC driver for macOS
• Download and install the ODBC driver for Linux

Download and install the ODBC driver for Windows

1. Go to the All ODBC Driver Versions - Windows download page.
2. Click the 32-Bit or 64-Bit link, depending on your operating system's architecture, for the latest version of the ODBC driver.
3. Extract the contents of the downloaded .zip file. For extraction instructions, see your operating system's documentation.
4. Double-click the extracted .msi file, and then follow the on-screen directions, to install the driver in C:\Program Files\Simba Spark ODBC Driver.
5. Go to Next steps.

Download and install the ODBC driver for macOS

1. Go to the All ODBC Driver Versions - Mac OS download page.
2. Click the 32-Bit link for the latest version of the ODBC driver.
3. Extract the contents of the downloaded .zip file. For extraction instructions, see your operating system's documentation.
4. Double-click the extracted .dmg file, and then follow the on-screen directions, to install the driver in /Library/simba/spark.
5. Go to Next steps.

Download and install the ODBC driver for Linux

1. Go to one of the following download pages, depending on your operating system's package manager type:

   • All ODBC Driver Versions - Linux (rpm)
   • All ODBC Driver Versions - Linux (deb)

2. Click the 32-Bit or 64-Bit link, depending on your operating system's architecture, for the latest version of the ODBC driver.

3. Extract the contents of the downloaded .zip file. For extraction instructions, see your operating system's documentation.

4. Install the ODBC driver, depending on your operating system's package manager type:

   • For Linux (rpm):

     sudo yum --nogpgcheck localinstall simbaspark_<version>.rpm
     

   • Linux (deb):

     sudo dpkg -i simbaspark_<version>.deb
     

   The installation directory is /opt/simba/spark.

5. Go to Next steps.

Next steps

To configure an Azure Databricks connection for the Databricks ODBC Driver, see the following articles:

• Compute settings for the Databricks ODBC Driver
• Authentication settings for the Databricks ODBC Driver
• Driver capability settings for the Databricks ODBC Driver
• Create an ODBC DSN for the Databricks ODBC Driver
• Create an ODBC DSN-less connection string for the Databricks ODBC Driver

For more information, see the Databricks ODBC Driver Guide.