How do EPHEMERAL dbt models work?

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

[Chillos]

The background music is very addictive haha. had to rewatch it again! Very well explained. thnx a lot!

[shubhamkumbhalpuri]

Hi Kahan,
It was really helpful and quality content playlist for DBT.
Thanks!

[hariharasudhan]

All your dbt videos are very useful. I request you to create a video on Incremental Model. It will be very helpful.

[turtleintelligence]

Amazing vidoes!! watching the 23rd of your video now! Great Content

[shayhalfon]

Hey Kahan, great videos!
I am trying to figure a way to add new columns to our 100 materialized models (some are incremental, tables) could you think of the best way doing so? I do not wish to go through over each model and add these columns.

Thanks!

Just a question why can't we write the cte in the main query itself instead of referring to the ephemeral?

[NT-muyl]

do ephemeral models reduce cost in the warehouse?

[mrsameenkhan]

Can you pass a parameter to the ephemeral model?

[vaibhavsingh]

Hey, Can you please tell me how can I configure my DBT model for Snowflake to 'Insert Overwrite' into a table in Public schema from staging schema.
What Materialization should be used here, what should be the incremental strategy?
I do not wants to recreate the table, only overwrite, also after overwritting the table should be table not converted to a view. Please help me!