Databricks pivot table reports

Databricks can be used as a live SQL data source via official ODBC driver. SeekTable is the perfect self-service BI interface for querying a Databricks data warehouse in a controlled and manageable way, making it accessible to non-IT users (without SQL knowledge).

Because report queries run and execute in real time, it's crucial that your Databricks data warehouse responds quickly. The execution time is limited by 2 minutes by default, this limit can be extended in a self-hosted SeekTable setup. For long-running queries you may consider to organize some kind of persisted cache layer (can be organized on SeekTable side too).

Databricks connection setup

1. Click the "Connect to Database" to open a new data cube configuration form.
2. Choose Data Source Type: SQL-compatible database (this opens SQL Settings section).
3. Choose Database Connector: Databricks
   On-prem SeekTable note: this option requires self-hosted SeekTable with Databricks ODBC driver installed. Please contact us to get deployment instructions.
4. Connection String example:

   Host=hostName;Port=443;HTTPPath=computeResourceHttpPath;SSL=1;AuthMech=3;UID=token;PWD=personal_access_token

   Host	The Databricks compute resource's Server Hostname value.
   Port	Port to use (443 by default).
   HTTPPath	The Databricks compute resource's HTTP Path value.
   AuthMech	Should be 3 for Databricks personal token or 11 for OAuth token.
   UID	Should be "token" for Databricks personal token.
   PWD	The Databricks personal access token for your workspace user.
   Auth_AccessToken	OAuth token.
   Auth_Flow	Should be 0 if OAuth token is used.

   How to get connecting string properties:

   • Host and HTTPPath: Get connection details for a Databricks compute resource
   • PWD (personal token): Databricks personal access token authentication
   • Auth_AccessToken (OAuth token): Authentication settings for the Databricks ODBC Driver - OAuth 2.0 tokens