The best data warehouse is a lakehouse
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.
Establish one single copy for all your data using open standards, and one unified governance layer across all data teams using standard SQL.
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
Open and reliable data lake as the foundation
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.
“The combination of Databricks and Fivetran has enabled us to build a robust and modern data pipeline in a very short amount of time. Fivetran had all the right connectors and integrations we needed.”
— Justin Wille, Director of Insights and Analytics, Kreg Tool
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.
“With data at our fingertips, we are much more confident knowing that we are using the most recent and complete data to feed our Power BI dashboards and reports.”
— Jake Stone, Senior Manager, Business Analytics, ButcherBox
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.
“Databricks SQL Serverless allows us to use the power of Databricks SQL while being much more efficient with our infrastructure.”
— R. Tyler Croy, Director of Platform Engineering, Scribd
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.
“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.”
— Stephane Caron, Sr. Director of Business Intelligence, CBC/Radio-Canada
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.
“Databricks is core to our business because its lakehouse architecture provides us a unified way to access, store and share actionable data.”
— Jagan Mangalampalli, Director of Big Data, Punchh
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.
“Databricks has provided one platform for our data and analytics teams to access and share data across ABN AMRO, delivering ML-based solutions that drive automation and insight throughout the company.”
— Stefan Groot, Head of Analytics Engineering, ABN AMRO
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.
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
BI and Dashboards
+ Any other Apache Spark™️ compatible client