dbt (data-build-tool)
4.0
(0)
9 learners
What you'll learn
This course includes
- 5.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 48 lessons • 5.5 hours of video
dbt (data-build-tool)
48 lessons
• 5.5 hours
dbt (data-build-tool)
48 lessons
• 5.5 hours
- Intro to Data Build Tool (dbt) // Create your first project!14:55
- 5 Tips to Improve Your dbt Project08:13
- Add raw "sources" to your dbt project10:43
- How does dbt actually compile queries?03:03
- Deploy to custom schemas & override dbt defaults06:41
- How to test and debug your dbt models06:07
- Change the materialization (aka how dbt models deploy)04:41
- Package management and dbt Hub // packages.yml02:52
- View your dbt documentation as a website03:41
- Use dbt Seeds to work with static CSV data05:09
- Create custom tests or override defaults08:20
- Add dbt project variables & use them in models05:13
- Use hooks to simplify repetitive dbt run activities07:06
- Simplify dbt documentation with docs blocks05:35
- How to monitor your source freshness in dbt07:35
- How to use Snowflake query tags in dbt02:45
- Use the dbt "state" method to only run modified models05:08
- The multi-repo approach // how to structure dbt projects06:46
- Audit your dbt runs by using {{ invocation_id }}04:28
- Install dbt in a virtual environment // best practice03:50
- How to "clean" your dbt project files03:33
- An EASY way to run/test models in groups06:05
- How do EPHEMERAL dbt models work?04:59
- Handle JSON with dbt // jinja & macros16:56
- How to use ONE dbt project for all environments07:23
- How to use the dbt "analyses" directory05:40
- A simple 4-step process for creating dbt models04:26
- How to use managed repos on dbt Cloud05:19
- Intro to dbt Cloud // Use Free for Life13:19
- 3 Time-Saving dbt Cloud Features (for free)04:13
- How to use Exposures in dbt06:46
- How to use dbt Operators to run dynamic commands07:45
- dbt Project Naming Conventions (recommended approach)07:10
- How to use dbt Snapshots to track data history10:54
- dbt Environments vs Targets | What's the Difference?10:21
- dbt & Reverse ETL | Census Integration & CI Checks07:08
- What are "intermediate" models in dbt?08:27
- How to Run Queries from the Terminal (dbt Show Command)04:36
- How to Build Incremental Models | dbt tutorial10:51
- How to Use Jinja w/ dbt Macros (3 Examples)11:34
- The Power of Naming in Data Projects (especially dbt)08:58
- SQL vs dbt Models (& the value of CTEs)04:08
- dbt vs Stored Procedures (3 key differences)10:27
- Creating a Data Model w/ dbt: Dimensions (Part 1/3)14:06
- Creating a Data Model w/ dbt: Facts (Part 2/3)08:40
- Creating a Data Model w/ dbt: Tests (Part 3/3)05:30
- Data Architecture w/ dbt: Putting It All Together09:02
- The Modern Data Viewpoint (3 Principles)08:43
