Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Use hooks to simplify repetitive dbt run activities
Play lesson

dbt (data-build-tool) - Use hooks to simplify repetitive dbt run activities

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

Summary

Keywords

Full Transcript

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- In this video I will walk through how to add "Hooks" to your project. We will create a simple audit table that will be populated before/after each run and model deployment by using this mechanism. What is dbt? dbt (data build tool) enables analytics engineers to transform data in their warehouses by simply writing select statements. dbt handles turning these select statements into tables and views. dbt does the T in ELT (Extract, Load, Transform) processes – it doesn’t extract or load data, but it’s extremely good at transforming data that’s already loaded into your warehouse. Timestamps: 0:00 - Intro 0:35 - Create an Audit Table 1:03 - on-run-start/end 2:25 - pre/post-hooks 4:17 - Using macros 6:21 - dbt-events-logging package 6:55 - Closing Title & Tags: How to Use Hooks | Data Build Tool (dbt) Tutorial #databuildtool #dataengineering #kahandatasolutions

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere