SQL in the Data Intelligence Platform

Introduction to Databricks

Kevin Barlow

Data Practitioner

Databricks SQL

The Data Intelligence Platform is designed to run your most challenging data warehousing workloads.

Lakehouse Diagram Generic

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!

SQL in the Data Intelligence Platform

Databricks Medallion Architecture

SQL in the Data Intelligence Platform

Benefits

Fully integrated
Scalable, performant compute
Great UI for analysts

Key Features

ANSI SQL
Enhanced Photon engine
Built-in visualizations

SELECT * 
FROM json.`/Volumes/
    catalog_name/schema_name/
    volume_name/path/to/data`

SELECT * 
FROM catalog_name.schema_name.table_name

CREATE TABLE 
    catalog_name.schema_name.table_name
AS
SELECT *
FROM ...

Let's review!

Introduction to Databricks