How do EPHEMERAL dbt models work?

[@KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures www.ModernDataCommunity.com

[@freefortravel4317]

Wonderful! So so helpful!!! +1 Can we get more of the complicated stuff? Example: How does dbt actually help in the datamodelling? Perhaps a dbt advanced user guide?

[@KahanDataSolutions]

@@freefortravel4317 Glad you found it helpful! I'm actually considering making a more in-depth training course on dbt (would cost $ though). Would that be of interest to you?

[@Chillos100]

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

[@KahanDataSolutions]

Glad you liked it!

[@turtleintelligence]

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

[@shayhalfon5460]

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!

[@mrsameenkhan]

Can you pass a parameter to the ephemeral model?

[@NT-mu1yl]

do ephemeral models reduce cost in the warehouse?

[@shubhamkumbhalpuri762]

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

[@KahanDataSolutions]

Thank you!

[@vaibhavsingh3247]

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!

[@KahanDataSolutions]

Sounds like you want to use the "incremental" materialization. Here are the docs: docs.getdbt.com/docs/build/incremental-models

[@hariharasudhan1839]

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

[@KahanDataSolutions]

Noted, thanks for the feedback! Glad you are finding the videos helpful.

[@9959]

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

[@KahanDataSolutions]

Good question - You certainly could and there is nothing stopping you from doing that. The main benefit is organization and separating logic if you'd like. It comes down to personal preference. Think of it like a different tool in your dbt toolbox to use as you see fit.