Databricks + Preset
Unlock the full potential of your Databricks lakehouse with Preset's open analytics platform. Native SQL Warehouse connectivity, Unity Catalog governance, and 40+ visualization types for your Delta Lake data.
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.
Unity Catalog governance
Preset respects your Unity Catalog permissions. Row-level security and column masking flow through automatically to your dashboards.
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.
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, 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 ready for self-serve analytics.
Learn More
Preset Docs: Databricks Connection
Step-by-step guide to connecting Preset to Databricks SQL Warehouse.
Learn more →Databricks Docs: Preset (AWS)
Official Databricks documentation for connecting Preset on AWS.
Learn more →Databricks Docs: Preset (Azure)
Official Azure Databricks documentation for connecting Preset.
Learn more →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.
Get in Touch
Get started with 5 users free forever. Connect to Databricks SQL in minutes and see your lakehouse data visualized. Fill out the form and we'll be in touch.