Overview of Databricks SQL

Databricks Concepts

Kevin Barlow

Data Practitioner

Lakehouse Diagram Generic

Databricks Concepts

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!

Databricks Concepts

Databricks SQL vs. other databases

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

Delta Lake Logo

Databricks Concepts

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

Databricks Concepts

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

Databricks Concepts

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

Databricks Concepts

SQL in the Lakehouse Architecture

Databricks Medallion Architecture

Databricks Concepts

Let's review!

Databricks Concepts

Preparing Video For Download...