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

  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:

  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.