Databricks SQL

The best data warehouse is a lakehouse

Get startedWatch demo

video

background-image

Databricks SQL (DB SQL) is a serverless data warehouse on the Databricks Lakehouse Platform that lets you run all your SQL and BI applications at scale with up to 12x better price/performance, a unified governance model, open formats and APIs, and your tools of choice – no lock-in.

Best price / performance

Lower costs, get best price/performance, and eliminate the need to manage, configure or scale cloud infrastructure with serverless.

Built-in governance

Establish one single copy for all your data using open standards, and one unified governance layer across all data teams using standard SQL.

Rich ecosystem

Use SQL and any tool like Fivetran, dbt, Power BI or Tableau along with Databricks to ingest, transform and query all your data in-place.

Break down silos

Empower every analyst to access the latest data faster for downstream real-time analytics, and go effortlessly from BI to ML.

How does it work?

Seamless integrations with the ecosystem

Ease of use

Real-world performance

Centralized governance

Open and reliable data lake as the foundation

background-image

Easily ingest, transform and orchestrate data from anywhere

Work with your data, no matter where it is. Turnkey capabilities allow analysts and analytic engineers to easily ingest data from anything like cloud storage to enterprise applications such as Salesforce, Google Analytics, or Marketo using Fivetran. It’s just one click away. Then, simply manage dependencies and transform data in-place with built-in ETL capabilities on the Lakehouse, or using your favorite tools like dbt on Databricks SQL for best-in-class performance.

Learn more →

Modern analytics and BI with your tools of choice

Work seamlessly with the most popular BI tools like Tableau, Power BI and Looker. Now analysts can use their favorite tools to discover new business insights on the most complete and freshest data. Databricks SQL also empowers every analyst to collaboratively query, find and share insights with the built-in SQL editor, visualizations and dashboards.

Learn more →

Eliminate resource management with serverless compute

Databricks SQL serverless removes the need to manage, configure or scale cloud infrastructure on the Lakehouse, freeing up your data team for what they do best. Databricks SQL warehouses provide instant, elastic SQL compute — decoupled from storage — and will automatically scale to provide unlimited concurrency without disruption, for high concurrency use cases.

Learn more →

Built from the ground up for best-in-class performance

Databricks SQL is packed with thousands of optimizations to provide you with the best performance for all your tools, query types and real-world applications. This includes the next-generation vectorized query engine Photon, which together with SQL warehouses, provides up to 12x better price/performance than other cloud data warehouses.

Learn more →

Centrally store and govern all your data with standard SQL

Establish one single copy of all your data using open format Delta Lake to avoid data lock-in, and perform in-place analytics and ETL/ELT on your Lakehouse — no more data movements and copies in disjointed systems. Then, easily discover, secure and manage all your data with fine-grained governance, data lineage, and standard SQL across clouds with Databricks Unity Catalog.

Learn more →

Built on a common data foundation, powered by the Lakehouse Platform

The Databricks Lakehouse Platform provides the most complete end-to-end data warehousing solution for all your modern analytics needs, and more. Get world-class performance at a fraction of the cost of cloud data warehouses. Speed up time from raw to actionable data at scale — and unify batch and streaming. Additionally, the Lakehouse lets data teams go from descriptive to predictive analytics effortlessly to uncover new insights.

Learn more →

Up to 12x better price/performance than other cloud data warehouses

Read more

Migrate to Databricks

Tired of the data silos, slow performance and high costs associated with legacy systems like Hadoop and enterprise data warehouses? Migrate to the Databricks Lakehouse: the modern platform for all your data, analytics and AI use cases.

Migrate to Databricks

Integrations

Seamless integrations with the ecosystem means maximum flexibility for your data teams. Ingest business-critical data with Fivetran, transform it in-place with dbt, and find new insights with Power BI, Tableau or Looker, all without moving your data into a legacy data warehouse.

Data Ingestion and ETL

Data Governance

BI and Dashboards

+ Any other Apache Spark™️ compatible client

“Now more than ever, organizations need a data strategy that enables speed and agility to be adaptable. As organizations are rapidly moving their data to the cloud, we’re seeing growing interest in doing analytics on the data lake. Databricks SQL delivers an entirely new experience for customers to tap into insights from massive volumes of data with the performance, reliability and scale they need. We’re proud to partner with Databricks to bring that opportunity to life.”

— Francois Ajenstat, Chief Product Officer, Tableau

Customer stories

Shell
Asurion customer story

Customer Story

Shell Logo
“Shell has been undergoing a digital transformation as part of our ambition to deliver more and cleaner energy solutions. As part of this, we have been investing heavily in our data lake architecture. Our ambition has been to enable our data teams to rapidly query our massive data sets in the simplest possible way. The ability to execute rapid queries on petabyte-scale data sets using standard BI tools is a game changer for us. Our co-innovation approach with Databricks has allowed us to influence the product roadmap, and we are excited to see this come to market.”

— Dan Jeavons, General Manager — Data Science, Shell

Abnormal
Asurion customer story

Customer Story

Abnormal Security uses Databricks Lakehouse to reduce email cyberattacks by 20%
Bread
Asurion customer story

Customer Story

Secure and personalized payment options for customers at scale
Butcherbox
Asurion customer story

Blog

How Butcherbox Uses Data Insights to Provide Quality Food Tailored to Each Customer’s Unique Taste
Atlassian
Atlassian customer story

Data + AI Summit

Building the lakehouse at Atlassian
CBC Radio Canada
Asurion customer story

Customer Story

Reimagining public broadcasting with personalization
Punchh
Atlassian customer story

Customer Story

Providing fast and actionable consumer analytics
Plume
Plume Customer Story

Data + AI Summit

Delivering insights from 20M+ smart homes with 500M+ devices
Comcast

Data + AI Summit

Powering telemetry analysis at Comcast with Databricks SQL
Nortwestern mutual
Northwestern mutual customer story

Blog

Driving transformation with a scalable, open lakehouse architecture
Asurion
Asurion customer story

Data + AI Summit

Implementing structured streaming on a large-scale lakehouse

Ready to get
started?

Get started guides

AWSAzureGCP

Related content

All the resources you need. All in one place.  Image

All the resources you need. All in one place.

Explore the resource library to find eBooks and videos on the benefits of a lakehouse.

Ready to get
started?

Get started guides

AWSAzureGCP