You can connect to a Databricks database in the Qlik Sense Add data or Data load editor dialogs.
The Databricks Connector connects to Databricks Workspace clusters and SQL Analytics SQL endpoints to query data in tables.
Information noteIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
Supported offerings
- Qlik Sense Enterprise SaaS
- Qlik Sense Enterprise on Windows
- QlikView (Requires separate installation)
Supported Databricks versions
The followings database versions are supported:
-
Databricks 5.5 to 7.6
Supported Databricks data types
The following Databricks data types are supported:
- BigInt
- Boolean
- Date
- Decimal
- Double
- Float
- Integer
- SmallInt
- String
- Timestamp
- TinyInt
- Varchar