Advanced Data Engineering with dbt-core and Amazon Redshift

Master advanced analytics engineering using dbt-core (v1.8, v2.0) and Amazon Redshift. Covers the full dbt-redshift adapter, Redshift-specific performance patterns (sort keys, dist styles, materialized views, late-binding views, Redshift Serverless), advanced incremental strategies including microbatch, model contracts, unit testing, dbt Mesh, Jinja2 macros and custom materializations, CI/CD pipelines, orchestration with AWS MWAA and Cosmos, the dbt Fusion engine, and dbt Wizard AI-assisted development.

Advanced8 Weeks11 LessonsNuniversity
Start

Course Content

  1. 01dbt-core Architecture and the dbt-redshift Adapter
  2. 02Redshift Performance Patterns: Sort Keys, Dist Styles, and Compression
  3. 03Materializations Deep Dive: Tables, Views, Late-Binding Views, and Redshift Materialized Views
  4. 04Advanced Incremental Models and the Microbatch Strategy
  5. 05Model Contracts, Unit Tests, and Data Quality
  6. 06Advanced Jinja2 Macros and Custom Materializations
  7. 07Snapshots, Seeds, and Advanced Sources
  8. 08CI/CD Pipelines and Slim CI on Redshift
  9. 09dbt Docs: Documentation, Lineage, and the dbt Docs v2 Catalog
  10. 10Essential dbt Packages for Production Projects
  11. 11dbt Fusion Engine and dbt Wizard

Lessons: 11 · 8 Weeks