SQL in the Data Intelligence Platform

Introduction to Databricks SQL

Kevin Barlow

Data Manager

Instructor Introduction

Kevin Headshot

Kevin Barlow
Data Manager

Who am I?

Professional in the data analytics industry with over a decade of working with different analytical tools.

Worked with companies of all sizes to deliver analytics solutions.

Extensive knowledge of the Databricks platform.

Introduction to Databricks SQL

Motivation

Data Warehouses

  • Great for SQL workloads
  • Typically expensive
  • Proprietary technologies
  • Limited capabilities and integrations

Data Warehouse Diagram

Data Lakes

  • Great for non-SQL workloads
  • Cost effective, lackluster performance
  • Open-source technologies
  • Unlimited capabilities

Data Lake Icon

Introduction to Databricks SQL

Data warehousing in the Lakehouse

Lakehouse Diagram

Introduction to Databricks SQL

Data warehousing in the Lakehouse

Data Warehouse - Lakehouse

Introduction to Databricks SQL

Benefits

  • Single architecture for all workloads
  • Flexibility and ownership with data
  • Open-source technologies
    • Delta
    • ANSI SQL
  • Cost effective solution

Lakehouse for BI Architecture

Introduction to Databricks SQL

Business Intelligence ecosystem

  • Integrate directly with your BI tool of choice
    • Partner Connect
    • Databricks Connect
    • JDBC / ODBC
  • Performance and scalability
  • Keep users where they are

BI Tool Integration

Introduction to Databricks SQL

Let's practice!

Introduction to Databricks SQL

Preparing Video For Download...