Member-only story
Learn dbt for Analytics Engineering
Models, macros, tests, seeds, documentation, snapshots, exposures
Kaustubh Gupta10 min read·Just now--
I work with SQL queries almost every day. Coming from a programming background, I have always wished for a modular way of writing SQL. I wanted support for variables, functions, configurations, and a dynamic transformation layer for my day-to-day job. That’s where dbt comes in.
Table of Contents
· Introducing dbt
· Myths About dbt
· Core Concepts in dbt
∘ dbt Project Structure
∘ Macros
∘ Models
∘ Materialization
∘ Tests
∘ Packages
∘ Seeds
∘ Documentation
∘ Snapshots
∘ Exposures
· Advanced Concepts
∘ Variables and Environment Management
∘ Hooks and Operations
∘ Node Selection and Tags
∘ The dbt build Command
· Conclusion