Databricks SQL is a serverless data warehouse built on lakehouse architecture that lets you run all your BI and ETL workloads 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.
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 Power BI and Tableau. 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
AI-powered performance is best in class
Databricks SQL utilizes our next-generation vectorized query engine Photon and 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 AI-powered predictive I/O that eliminates performance tuning like indexing by intelligently prefetching data using neural networks.
“The Databricks Data Intelligence 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
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 Data Intelligence Platform: the modern platform for all your data, analytics and AI use cases.
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