Download and install the Databricks ODBC Driver (Simba)

This page describes how to download and install the Databricks Apache Spark ODBC Driver.

Before you download and install the driver, review the JDBC ODBC driver license.

Some tools and clients require you to install the ODBC driver before you can set up a connection to 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

The download process prompts you to log in to Databricks and accept the terms.

important

If you use Databricks on AWS GovCloud, contact your account team to receive access to the driver.

Download and install the ODBC driver for Windows

1. Go to the All ODBC Driver Versions - Windows download page.
2. Choose 32-Bit or 64-Bit, depending on your operating system's architecture, for the latest version of the ODBC driver. The download process prompts you to log in to Databricks and accept the driver license terms.
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. Choose 32-Bit for the latest version of the ODBC driver. The download process prompts you to log in to Databricks and accept the driver license terms.
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. Choose 32-Bit or 64-Bit, depending on your operating system's architecture, for the latest version of the ODBC driver. The download process prompts you to log in to Databricks and accept the driver license terms.

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):

     Bash

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

   • Linux (deb):

     Bash

     sudo dpkg -i simbaspark_<version>.deb

   The installation directory is /opt/simba/spark.

5. Go to Next steps.

Next steps

To configure a Databricks connection for the Databricks ODBC Driver, see the following pages:

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

For more information, see the Databricks ODBC Driver Guide (HTML or PDF).