dbt (data-build-tool) - How do EPHEMERAL dbt models work?

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

dbt tutorial install dbt create dbt project how to install dbt Data Build Tool data build tool dbt dbt core intro to dbt data transformation SQL SQL Tutorial Learn SQL

Full Transcript

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- Let's talk about one of the more unique materializations within dbt - ephemeral! In this video we will walk through how to create one and review some of the pros & cons to consider when adding them to your project. What is an ephemeral model? Ephemeral models are not directly built into the database. Instead, dbt will interpolate the code from this model into dependent models as a common table expression. Timestamps: 0:00 - Intro 0:23 - Creating an Ephemeral Model 3:20 - Review Pros & Cons 4:44 - Closing Title & Tags: Understanding Ephemeral Models | data-build-tool (dbt) Tutorial #kahandatasolutions #dataengineering #dbttraining