Search⌘ K
AI Features

Ephemeral Models

Explore how to use ephemeral models in dbt to perform intermediate transformations without storing data physically. Understand how dbt wraps these queries as CTEs, allowing efficient referencing within other models and enhancing pipeline flexibility.

Introduction to ephemeral models

Sometimes, we want to apply intermediate transformations to our models, but we don’t necessarily need to store ...