The problem I’m having
Similar to the link below, I wanted to use is_incremental() logic in the
I think I have a workaround in local development using the full refresh flag in the ephemeral models below to basically mimic the is_incremental() variable, but not sure if this is a valid solution/there’s something more obvious. It looks like the is_incremental() variable can’t be picked up in ephemerals.
Different than the case linked below, there are CTEs within the ephemerals that are long running, so being able to put the is_incremental() (or equivalent) in those CTEs directly is necessary to improve runtime.
{% set is_incremental_run = (flags.FULL_REFRESH == false) %}
The context of why I’m trying to do this
Want to create ephemerals for general organization of queries and to not clutter the data warehouse, but also want to be able to use incremental logic in those ephemerals.
What I’ve already tried
Other related thread that I found from a while back