██████╗ ███████╗████████╗ ███╗ ███╗ ██████╗ ██████╗ ███████╗ ██████╗ ██╗ ██╗████████╗
██╔════╝ ██╔════╝╚══██╔══╝ ████╗ ████║██╔═══██╗██╔══██╗██╔════╝ ██╔═══██╗██║ ██║╚══██╔══╝
██║ ███╗█████╗ ██║ ██╔████╔██║██║ ██║██████╔╝█████╗ ██║ ██║██║ ██║ ██║
██║ ██║██╔══╝ ██║ ██║╚██╔╝██║██║ ██║██╔══██╗██╔══╝ ██║ ██║██║ ██║ ██║
╚██████╔╝███████╗ ██║ ██║ ╚═╝ ██║╚██████╔╝██║ ██║███████╗ ╚██████╔╝╚██████╔╝ ██║
╚═════╝ ╚══════╝ ╚═╝ ╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═╝╚══════╝ ╚═════╝ ╚═════╝ ╚═╝
██████╗ ███████╗ ██╗ ██╗ ██████╗ ██╗ ██╗██████╗ ██████╗ █████╗ ██████╗
██╔═══██╗██╔════╝ ╚██╗ ██╔╝██╔═══██╗██║ ██║██╔══██╗ ██╔══██╗██╔══██╗██╔════╝
██║ ██║█████╗ ╚████╔╝ ██║ ██║██║ ██║██████╔╝ ██║ ██║███████║██║ ███╗
██║ ██║██╔══╝ ╚██╔╝ ██║ ██║██║ ██║██╔══██╗ ██║ ██║██╔══██║██║ ██║
╚██████╔╝██║ ██║ ╚██████╔╝╚██████╔╝██║ ██║ ██████╔╝██║ ██║╚██████╔╝
╚═════╝ ╚═╝ ╚═╝ ╚═════╝ ╚═════╝ ╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═╝ ╚═════╝
In this workshop, you’ll learn how to create and document macros that leverage the powerful introspective features of dbt to perform dynamic modeling including: magic number lookup macros, run result storage in your warehouse, and model reference rule enforcement.
This dbt project repository is used as part of the Get more out of your DAG workshop presented at coalesce 2022.
The slide deck for this workshop presentation can be found here.
This workshop includes material from the following authors:
- @nicholasyager
- @wasilaq