• Syntax overview - dbt’s note selection syntax
• Optimizing VS Code for dbt on Mac - awesome vs code setup for dbt, article written specifically for Mac but same could be done for Windows
• Pro tips for workflows - advanced dbt workflows
• Youtube: Create Modular Date Models - presentation explaining how you can refactor dbt data models to make them more structured and performant
• Project Checklist: DAG Auditing

DBT saves artifacts when jobs are run which allows for creating powerful workflows. The states of commands are saved as artifacts. For example, the below code will reference the status of the data’s freshness and only build models that are “fresh”.

# Command step order
dbt source freshness
dbt build --select source_status:fresher+