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 • 44 lessons • 5.5 hours of video
dbt (data-build-tool)
44 lessons
• 5 hours
dbt (data-build-tool)
44 lessons
• 5 hours
- Intro to Data Build Tool (dbt) // Create your first project! 14:55
- 5 Tips to Improve Your dbt Project 08:13
- Add raw "sources" to your dbt project 10:43
- How does dbt actually compile queries? 03:03
- Deploy to custom schemas & override dbt defaults 06:41
- How to test and debug your dbt models 06:07
- Change the materialization (aka how dbt models deploy) 04:41
- Package management and dbt Hub // packages.yml 02:52
- View your dbt documentation as a website 03:41
- Use dbt Seeds to work with static CSV data 05:09
- Create custom tests or override defaults 08:20
- Add dbt project variables & use them in models 05:13
- Use hooks to simplify repetitive dbt run activities 07:06
- Simplify dbt documentation with docs blocks 05:35
- How to monitor your source freshness in dbt 07:35
- How to use Snowflake query tags in dbt 02:45
- Use the dbt "state" method to only run modified models 05:08
- The multi-repo approach // how to structure dbt projects 06:46
- Audit your dbt runs by using {{ invocation_id }} 04:28
- Install dbt in a virtual environment // best practice 03:50
- How to "clean" your dbt project files 03:33
- An EASY way to run/test models in groups 06:05
- How do EPHEMERAL dbt models work? 04:59
- Handle JSON with dbt // jinja & macros 16:56
- How to use ONE dbt project for all environments 07:23
- How to use the dbt "analyses" directory 05:40
- A simple 4-step process for creating dbt models 04:26
- How to use managed repos on dbt Cloud 05:19
- Intro to dbt Cloud // Use Free for Life 13:19
- 3 Time-Saving dbt Cloud Features (for free) 04:13
- How to use Exposures in dbt 06:46
- How to use dbt Operators to run dynamic commands 07:45
- dbt Project Naming Conventions (recommended approach) 07:10
- How to use dbt Snapshots to track data history 10:54
- dbt Environments vs Targets | What's the Difference? 10:21
- dbt & Reverse ETL | Census Integration & CI Checks 07: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 tutorial 10: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
- Data Architecture w/ dbt: Putting It All Together 09:02
- The Modern Data Viewpoint (3 Principles) 08:43
