← Package directory
Available on winget

Install Simba Spark ODBC Driver

Simba Apache Spark ODBC Connector for direct SQL and HiveQL access to Apache Hadoop/Spark distributions.

Install with winget
winget install --id Databricks.SparkODBCDriver
Upgrade
winget upgrade --id Databricks.SparkODBCDriver
Uninstall
winget uninstall --id Databricks.SparkODBCDriver

About Simba Spark ODBC Driver

The Simba Apache Spark ODBC Connector is used for direct SQL and HiveQL access to Apache Hadoop / Spark distributions, enabling Business Intelligence (BI), analytics, and reporting on Hadoop-based data. The connector efficiently transforms an application’s SQL query into the equivalent form in HiveQL, which is a subset of SQL-92. If an application is Spark-aware, then the connector is configurable to pass the query through to the database for processing. The connector interrogates Spark to obtain schema information...

What's new in 2.9.2

Enhancements & New Features * [SPARKO-1408] Process Name as Default UserAgentEntry The driver will now use the process name as the UserAgentEntry if the UserAgentEntry is not set. * [SPARKO-1472] Upgraded LTS support The driver now uses LTS versions 11.3 through 15.4. For supported versions, see the Installation and Configuration Guide. * [SPARKO-1482][05221097] Databricks domains support The driver now supports cloud.databricks.us and cloud.databricks.mil domains. * [SPARKO-1325][SPARKO-1435] Timestamp_NTZ support The driver now recognizes timestamp_ntz columns in the following data source tables: - SQLGetTypeInfo (SQL_ALL_TYPES) now lists timestamp_ntz as an available type. - SQLGetTypeInfo (SQL_TIMESTAMP) now lists timestamp_ntz as one of the types that map to SQL timestamps. - SQLColumns now identifies timestamp_ntz columns correctly. - If UseNativeQuery is set to 0, SQLColAttribute (SQL_DESC_TYPE_NAME) identifies timestamp_ntz columns correctly. * [SPARKO-1384][SPARKO-1405][SPARKO-1411] CRL cache support On Windows, the driver supports the CRL cache when UseSystemTruststore is enabled (set to 1). * [SPARKO-1399][SPARKO-1417] Updated third-party libraries The connector now uses the following third-party libraries: - OpenSSL 3.0.16 (previously 3.0.15) - libcURL 8.12.1 (previously 8.11.0) - Expat 2.7.1 (previously 2.6.3) * [SPARKO-1404] VOID type support The driver now supports VOID columns and lists them correctly in SQLGetColumns calls. * [SPARKO-1419][SPARKO-1420] OAuth Token exchange support The driver now supports OAuth Token exchange feature for IDP different from t...

Read release notes

Version history

Version Updated Notes
2.9.2 Unknown Enhancements & New Features * [SPARKO-1408] Process Name as Default UserAgentEntry The driver will now use the process name as the UserAgentEntry if the UserAgentEntry is not set. * [SPARKO-1472] Upgraded LTS support The...
2.9.1.1001 Unknown Enhancements & New Features * [SPARKO-1383] Updated Thrift Version for HTTP User-Agent Header The HTTP User-Agent used by the driver has been updated from thrift/0.9.0 to thrift/0.17.0. * [SPARKO-1005] Driver-Side Timeou...