Introducing dbt

Introduction to dbt

Mike Metzger

Data Engineer

dbt defined

  • "data build tool"
  • Primarily handles the T in ELT (sometimes ETL)
  • Allows easy switching between data warehouses
  • Provides SQL collaboration
  • Translates between SQL dialects

dbt logo

Introduction to dbt

What does dbt do?

  • Primarily defines data models and transformations using SQL
    • eCommerce, mobile app interactions, etc
  • Can define relationships between data models
    • Customers, Addresses, Orders
  • Runs the data transformation process(es)
    • Converting raw data from log files to database tables
  • Can test for data quality requirements
Introduction to dbt

What does dbt look like?

  • Also known as dbt-core, open-source
    • Command-line tool available for Mac, Windows, Linux
  • dbt Cloud is proprietary
  • Main command dbt
    • dbt
    • dbt --version
    • dbt -h

dbt core logo

Introduction to dbt

Who is dbt for?

dbt is designed for any users that need to transform data:

  • Data Engineers
  • Analytics Engineers
  • Data Analysts

engineer

1 Photo by Christina @ wocintechchat.com on Unsplash
Introduction to dbt

Let's practice!

Introduction to dbt

Preparing Video For Download...