Databricks BI Tool for pivot tables, charts, tabular reports

SeekTable is a self-service Databricks BI tool that allows users to create pivot tables, charts, and flat table reports directly from Databricks databases:

• Live Databricks connection: report queries execute in real-time, meaning your operational reports always up-to-date (no need in refreshes).
• No ETL / zero data extraction: analyze massive datasets directly in your data warehouse, no data imports required.
• Designed for business users: Excel-like web interface enables non-IT users to perform fast data analysis and data visualization without writing SQL or exporting sensitive data.
• Governed data access: safely share common reports and data cubes with RLS. End-users queries are limited to configured data models (no direct SQL access to Databricks).
• On-premise reporting tool: self-hosted SeekTable meets strict corporate compliance and data governance requirements. It supports fully isolated deployment environments to deliver real-time insights without your data ever leaving your internal network.
• Embedded BI: seamlessly integrate SeekTable published reports and dashboards directly into your web app. Or embed the entire SeekTable app view to let them build their own reports directly inside your app.
• White-labeling: apply your own logo, branding, and UI styles to make SeekTable look exactly like your company's own in-house reporting solution.

Setup Databricks Connection

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