Skip to main content
DATABRICKS SQL

The Best Data Warehouse Is a Lakehouse

Eliminate legacy warehouse costs and lower TCO with a serverless intelligent data warehouse
DBSQL
TOP TEAMS SUCCEED WITH AN INTELLIGENT DATA WAREHOUSE
Benefits

AI-powered performance and simplicity

Eliminate the cost and complexity of legacy data warehouses with Databricks SQL — a serverless data warehouse built on lakehouse architecture that natively integrates AI.

Intelligent experiences

Let everyone in your organization self-serve data-driven answers using natural language queries, thanks to AI-powered experiences that understand the unique semantics of your data and your business. Data architects can also write SQL in the SQL editor, which uses AI to generate and fix SQL code.

Predictive optimizations

Deliver high performance, efficiency and resiliency automatically, which can eliminate the overhead of having to manually tune your data warehouse. Databricks SQL also reduces operating costs through time savings and through more efficient provisioning.

World-class price/performance

Improve TCO for your BI and ETL workloads. Save on compute and storage costs with a lakehouse architecture powered by the Photon query engine. These capabilities help you easily predict growth requirements and maintain sustainable budget growth.

Features

AI-powered lakehouse

Less tuning your data warehouses, more answers from your data. All with market-leading price/performance.

Democratize analytics and insights across your organization. Accurately answer your data questions, because AI/BI understands your data and continuously improves.

Learn more about AI/BI
AI/BI

Get the best price/performance with instant and elastic compute, lower cost and completely managed infrastructure.

Watch the video outlining serverless security
Serverless

Unify your analytics data with open table formats (OTFs) so your data stays portable, with no vendor lock-in.

Learn more
Lakehouse storage

Databricks SQL easily connects BI tools (Power BI, Tableau and more) to your lakehouse for fast performance, low latency and high user concurrency to your data lake.

Understand how to connect to popular BI tools
Simple BI tool integration

Unified governance and security to centrally manage your assets and access with integrated Unity Catalog.

Comprehensive guide to data and AI governance
Unified governance

Discover, query and govern all your data in one place. Use federation to expose, query and govern siloed data systems as an extension of your lakehouse.

Watch the Lakehouse Federation video
Lakehouse Federation

More features

Security

Comprehensive security to protect your data and workloads, such as encryption, network controls, data governance and auditing.

More about our security controls and compliance certifications

Storage

A lakehouse is a format-agnostic architecture combining the price/performance and scale of data lakes with the data management and ACID transactions of data warehouses.

Learn more about the lakehouse architecture

AI-driven performance

AI-driven performance to intelligently route queries, plan and execute quickly with intelligent data retrieval and writes, and accelerate data access.

Read this performance blog

Data integration and ingestion

With native ingestion capabilities and a broad partner ecosystem, you can ingest from nearly any source with simple, scalable and cost-effective integrations.

More about data engineering

Data sharing

The Databricks Data Intelligence Platform makes it easier to get the data and insights you need by helping you share data, AI and solutions in a unified way.

More about Delta Sharing

Lakehouse Monitoring

Track and confirm the quality and consistency of your data over time. The tables created by Databricks Lakehouse Monitoring can alert you to data changes and help you identify the causes.

Learn more about Lakehouse Monitoring

SQL authoring

Build SQL queries with Databricks Assistant, connect to participating apps, tools, clients, SDKs and APIs, and use built-in functions for AI and geospatial.

Read the documentation
use cases

An open, unified approach to your data, BI and AI workloads

AI-optimized performance

AI-optimized performance

Databricks SQL uses AI systems throughout the platform that analyze your workloads and automatically improve efficiency and performance. Customers report a 77% perfomance improvement for repeating workloads over two years.
  • 9x better ETL price/performance
  • The Photon query engine for extremely fast query performance at low cost
  • Process large numbers of queries quickly and cost-effectively with intelligent workload management
  • Automatically rewrite data files to improve data layout
  • Maintain both high performance and high BI query concurrency
  • 4x improvement on throughput using ai_query()
Pricing

Usage-based pricing keeps
spending in check

Only pay for the products you use at per-second granularity.
Related Products

Discover more

Learn more about the integrated features of Databricks SQL.

Unity Catalog

Unified governance and security to centrally manage assets and access with integrated Unity Catalog.

AI/BI

Dashboards provide a low-code experience for analysts. Genie helps business users ask questions of their data and self-serve their own analytics.

Delta Sharing

The open source approach of Delta Sharing lets you share live data across platforms, clouds and regions without sacrificing strong security and governance.

Databricks Workflows

Define, manage and monitor multitask workflows with Databricks Workflows, a managed orchestration service that’s fully integrated into Databricks SQL.

Photon

Photon is the next-generation engine built into Databricks SQL that provides extremely fast query performance at low cost.

The Databricks Data Intelligence Platform

Explore the full range of tools available on the Databricks Data Intelligence Platform to seamlessly integrate data and AI across your organization.

Take the next step

Ready to become a
data + AI company?

Take the first steps in your data transformation