Databricks SQL

The best data warehouse is a lakehouse

Erste SchritteDemo ansehen

Video

Hintergrundbild

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.

Wie funktioniert es?

Seamless integrations with the ecosystem

Anwenderfreundlichkeit

Real-world performance

Zentralisierte Governance

Open and reliable data lake as the foundation

Hintergrundbild

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.

Weitere Informationen →

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 quickly visualize and analyze the freshest data with 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.

Weitere Informationen →

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.

Weitere Informationen →

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.

Weitere Informationen →

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.

Weitere Informationen →

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.

Weitere Informationen →

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

Weiterlesen

Integrationen

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

+ jeder sonstige Apache Spark™-kompatible 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
Kundenbericht Asurion

Kundenbericht

Shell Logo
„Die digitale Transformation von Shell ist Teil unseres Bestrebens, Lösungen für mehr und sauberere Energielösungen bereitzustellen. Daher haben wir erhebliche Investitionen in unsere Data-Lake-Architektur getätigt. Ziel ist es, dafür zu sorgen, dass unsere Datenteams die riesigen Datensätze möglichst unkompliziert abfragen können. Die Möglichkeit, mit BI-Standard-Tools schnelle Abfragen für Datensätze in Petabyte-Größenordnung durchzuführen, ist für uns ein entscheidender Vorteil. Unser gemeinsam mit Databricks entwickelter Ansatz ermöglicht es uns, Einfluss auf die Produkt-Roadmap zu nehmen, und wir sind begeistert, die Markteinführung erleben zu dürfen.“

– Dan Jeans, General Manager Data Science, Shell

Abnormal
Kundenbericht Asurion

Kundenbericht

Abnormal Security reduziert Cyberangriffe auf E-Mails mit Databricks Lakehouse um 20 %
Bread
Kundenbericht Asurion

Kundenbericht

Sichere und umfassend personalisierte Zahlungsoptionen für Kunden
Butcher box
Kundenbericht Asurion

Blog

So liefert Butcherbox auf Grundlage von Datenerkenntnissen hochwertige Lebensmittel, die auf den individuellen Geschmack jedes einzelnen Kunden zugeschnitten sind
Atlassian
Kundenbericht Atlassian

Data + AI Summit

Einrichtung eines Lakehouse bei Atlassian
CBC Radio Canada
Kundenbericht Asurion

Kundenbericht

Neukonzeption des öffentlichen Rundfunks durch Personalisierung
Punchh
Kundenbericht Atlassian

Kundenbericht

Bereitstellen schneller und umsetzbarer Verbraucheranalysen
Plume
Kundenbericht Plume

Data + AI Summit

Bereitstellung aussagekräftiger Daten aus über 20 Mio. Smart Homes mit mehr als 500 Mio. Geräten
Comcast

Data + AI Summit

Telemetrieanalyse bei Comcast mit Databricks SQL
Northwestern Mutual
Kundenbericht Northwestern Mutual

Blog

Driving transformation with a scalable, open lakehouse architecture
Asurion
Kundenbericht Asurion

Data + AI Summit

Strukturiertes Streaming in einem groß angelegten Lakehouse implementieren

Kann's
losgehen?

Einstiegshandbücher

AWSAzureGCP