The ELT pattern in action with DBT and SQLMesh
summary
This talk shows how to implement the ELT (Extract-Load-Transform) pattern using SQL-based transformations inside a data warehouse, with concrete examples on real data. It compares two tools—DBT and SQLMesh—examining their templating, orchestration, and lineage features, runs pipelines on Google BigQuery, and includes DevOps automation aspects.
AI-written summary · about
chapters (7)
- 0:00ELT pattern intro
- 8:58Use case and demo
- 12:28ELT demo Airflow BigQuery
- 26:35SQL transformations dbt
- 35:08Exploring dbt features
- 43:44SQLMesh unique approaches
- 51:07DBT vs SQLMesh
related talks
39mWhat if SQL was back in fashion?
01h 42mFall in Love with Data Transformation: DBT as Your Weapon
36mBeyond dbt: Modern SQL Transformation and Lineage with SQLGlot and SQLMesh
01h 28mA Guide to the Modern Data Stack
16mETL vs ELT: Why the T has shifted
41mModern Data Architectures – What They Are and How to Implement?
38mReigniting the ETL vs. ELT Debate - Which Better Supports the Business?
51mFrom SQLi Hammer to Full-fledged Software Engineer