Data + AI Summit 2022: June 27–30, Moscone Center + Virtual  Image

Data + AI Summit 2022: June 27–30, Moscone Center + Virtual

Join us for unique community-driven content, deep technical training and outstanding speakers like Andrew Ng and Ali Ghodsi.

background-image

Databricks SQL

Data Warehousing on the Lakehouse

Try for freeSchedule a demo

background-image

Databricks SQL (DB SQL) allows customers to operate a multicloud lakehouse architecture that provides up to 12x better price/performance than traditional cloud data warehouses. Using open source standards to avoid data lock-in, it provides the reliability, quality and performance that data lakes natively lack.

Analytics on all your data with your tools of choice

Leverage your preferred tools like dbt, Fivetran, PowerBI or Tableau to ingest, query and analyze the most recent and complete data, without having to move it into a separate data warehouse. DB SQL also empowers every analyst across your organization to quickly find and share new insights with the built-in SQL editor, visualizations and dashboards.

Simplified administration and governance

Quickly setup instant, elastic SQL compute decoupled from storage with serverless. Databricks automatically determines instance types and configuration for the best price/performance. Then, easily manage users, data, and resources with endpoint monitoring, query history, and fine-grained governance.

In-place, lightning-fast analytics on data lake data

Gain a competitive edge by running SQL queries on your lakehouse with data warehousing performance at data lake economics. DB SQL brings reliability, quality, security and performance to your data lake to support traditional analytics workloads using your most recent and complete data.

background-image

How does it work?

Connect with your existing tools - Databricks SQL

Connect with your existing tools

Connect your favorite BI tools like dbt, PowerBI and Tableau, and benefit from fast performance, low latency and high user concurrency to your data lake data. Setting up reliable connections to your Delta Lake tables is simple, and you can integrate your existing authentication solution. Re-engineered ODBC/JDBC drivers provide lower latency and less overhead to reduce round trips by 0.25 seconds. Data transfer rate is improved 50%, and metadata retrieval operations execute up to 10x faster.

Learn more →

Best price/performance for query execution

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

Learn more →

Performance chart

shared end point sreenshot

Simplified administration and governance for your lakehouse

Databricks SQL makes it easy to set up and manage SQL compute resources, thanks to a central log that records usage across virtual clusters, users and time. This makes it easier to observe workloads across DB SQL, third-party BI tools and any other SQL clients in one place, which in turn helps triage errors and performance issues. Administrators can then drill down into the phases of each query’s execution to troubleshoot problems and support audits.

Databricks SQL - First-class SQL development experience

First-class SQL development experience

DB SQL query editor allows analysts to write queries in a familiar syntax (ANSI SQL) and easily explore data in place in the lakehouse. Analysts can easily make sense of query results through a wide variety of rich visualizations, and quickly build and share dashboards with stakeholders.

Learn more →

Quickly discover and share new insights

Analysts can easily make sense of query results through a wide variety of rich visualizations, and quickly build dashboards with an intuitive drag-and-drop interface. To keep everyone current, dashboards can be shared and configured to automatically refresh, as well as to alert the team to meaningful changes in the data.

Quickly discover and share new insights

Use cases

Enable your lakehouse infrastructure

Operate a multicloud lakehouse architecture that provides data warehouse performance at data lake economics. Databricks SQL enables analysts and data scientists to reliably perform SQL queries and BI directly on the freshest and most complete data using their tools of choice — directly on your data lake — while greatly simplifying architectures by reducing the need for more disparate systems.

Leverage your existing BI tools

Enable business analysts to directly query data lake data using their favorite BI tool like PowerBI or Tableau, and avoid data silos. Re-engineered and optimized connectors ensure fast performance, low latency and high user concurrency to your data lake. Now analysts can use the best tool for the job on one single source of truth for your data.

Collaboratively explore the freshest data

Enable every analyst and SQL professional in your organization to quickly find and share new insights with a collaborative and self-served analytics experience. Confidently manage data permissions with fine-grained governance, share and reuse queries, and quickly analyze and share results with interactive visualizations and dashboards.

Build custom data apps

Build rich and custom data-enhanced applications for your own organization or your customers. Benefit from the ease of connectivity, management and better price/performance of DB SQL to simplify development of data-enhanced applications at scale, all served from your data lake.

Integrations

Seamless integrations with the modern data stack 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.

Easily connect Databricks with Tableau, PowerBI, Looker, Fivetran, dbt and your favorite tools

“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.

The introduction of 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

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

Data + AI Summit

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 scalable, open lakehouse architecture
Asurion
Asurion customer story

Data + AI Summit

Implementing structured streaming on a large-scale lakehouse

Customers

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

Atlassian logo

“At Atlassian, we need to ensure teams can collaborate well across functions to achieve constantly evolving goals. A simplified lakehouse architecture would empower us to ingest high volumes of user data and run the analytics necessary to better predict customer needs and improve the experience of our customers.
A single, easy-to-use cloud analytics platform allows us to rapidly improve and build new collaboration tools based on actionable insights.”

— Rohan Dhupelia, Data Platform Senior Manager, Atlassian

Bread logo

“Moving from Snowflake to Databricks’ lakehouse has transformed the way we drive business actions based on the most complete and current view of our data, something that wasn’t possible with our data warehouse before.”

— Christina Taylor, Staff Data Engineer, Bread

Abnormal logo

“Databricks Lakehouse enables us to organize and leverage all our data at scale, to power analytics in an effort to detect and block all forms of email attacks for our customers, including targeted socially engineered email attacks that evade traditional defenses.”

— Sanny Liao, Head of Data Science at Abnormal Security

CBC logo

“The Databricks Lakehouse Platform has enabled us to run analytics that reduce the time it takes to derive insights from audience behaviors from weeks to minutes, so we can quickly adapt to deliver the programming that will resonate better with our listeners.”

— Stephane Caron, Sr. Director of Business Intelligence at CBC/Radio-Canada

Ready to get started?

Get started guides

AWSAzure