Open Analytics for Your Databricks Lakehouse
Connect Preset to Databricks SQL Warehouse and unlock 40+ visualizations, self-serve analytics, and embedded dashboards for your Delta Lake data—without legacy BI limitations.
Open analytics for your lakehouse
Native Databricks SQL connectivity
Connect directly to Databricks SQL Warehouse with your access token. Query Delta Lake tables, views, and Unity Catalog objects seamlessly.
40+ visualization types
Go beyond basic charts. Create geographic maps, pivot tables, funnels, Sankey diagrams, and more—all from your Databricks data.
SQL Lab for exploration
Powerful SQL IDE with autocomplete, schema browser, and query history. Explore your lakehouse data and save queries as reusable datasets.
Unity Catalog governance
Preset respects your Unity Catalog permissions. Row-level security and column masking flow through automatically.
Scheduled reports & alerts
Automate dashboard delivery via Slack or email. Set up alerts to notify teams when metrics cross thresholds.
Embedded analytics
Embed Databricks-powered dashboards in your applications with our SDK. Row-level security for multi-tenant use cases.
Connect Preset to Databricks in minutes
1. Get your credentials
From your Databricks workspace, grab your SQL Warehouse HTTP path and generate a personal access token (or use a service principal).
2. Add the connection in Preset
In Preset, add a new Databricks database connection. Enter your workspace URL, HTTP path, token, and optional catalog/schema.
3. Start visualizing
Browse your Delta Lake tables, create datasets, and build dashboards. Your Databricks data is now ready for self-serve analytics.
Databricks + Preset FAQ
Both Classic and Serverless SQL Warehouses work with Preset. Serverless is recommended for most use cases due to instant startup and auto-scaling. For predictable heavy workloads, Classic with auto-stop can be more cost-effective.
Yes. In Preset, you can add multiple Databricks connections—useful for connecting dev, staging, and production workspaces or different Unity Catalog catalogs.
Preset caches query results to reduce load on your SQL Warehouse. You can configure cache TTL per dataset. For real-time dashboards, set shorter cache durations or disable caching.
Preset supports Databricks personal access tokens and service principal authentication. For production, we recommend service principals with appropriate Unity Catalog grants.
Try Preset with your Databricks data—free
Get started with 5 users free forever. Connect to Databricks SQL in minutes and see your lakehouse data visualized.
