Overview of Databricks SQL

Concetti di Databricks

Kevin Barlow

Data Practitioner

Lakehouse Diagram Generic

Concetti di Databricks

Databricks for SQL Users

Databricks SQL Lakehouse Diagram

Databricks SQL
  • Data Warehousing for the Lakehouse
  • Familiar environment for SQL users
  • SQL-optimized performance (Photon)
  • Connect to your favorite BI tools

Comes built into the platform!

Concetti di Databricks

Databricks SQL vs. other databases

Databricks SQL
  • Open file format (Delta)
Other Data Warehouses
  • Proprietary data format

Delta Lake Logo

Concetti di Databricks

Databricks SQL vs. other databases

Databricks SQL
  • Open file format (Delta)
  • Separation of compute and storage
Other Data Warehouses
  • Proprietary data format
  • Storage often tied to compute

Databricks Data Plane

Compute ans storage

Concetti di Databricks

Databricks SQL vs. other databases

Databricks SQL
  • Open file format (Delta)
  • Separation of compute and storage
  • ANSI SQL
Other Data Warehouses
  • Proprietary data format
  • Storage often tied to compute
  • Tech-specific SQL

ANSI Logo

SQL Structure

Concetti di Databricks

Databricks SQL vs. other databases

Databricks SQL
  • Open file format (Delta)
  • Separation of compute and storage
  • ANSI SQL
  • Integrated into other data workloads
Other Data Warehouses
  • Proprietary data format
  • Storage often tied to compute
  • Tech-specific SQL
  • Usually lacking advanced analytics

Databricks Logo

Postgres Logo

Concetti di Databricks

SQL in the Lakehouse Architecture

Databricks Medallion Architecture

Concetti di Databricks

Let's review!

Concetti di Databricks

Preparing Video For Download...