Shangwei Wang
08/11/2023, 3:40 AMdbt_metrics_default_calendar
which is something coming from using dbt “metrics” (i.e. this is not something we manage/define ourselves). This model practically never changes (it is a date spine through 2030), and many of our models depends on it. if i configure auto-materialization with freshness policy for the models that depend on this date spine, how do i configure these models without having to waste time/resource on materializing this date spine (since the data won’t change until 2030)? Thanks!rex
08/11/2023, 3:58 PMowen
08/11/2023, 8:56 PMdbt_metrics_default_calendar
, which it sounds like you would not be able to do as this is a built-in model). However, we're looking into expanding options on the eager auto materialize policy (which would not be impacted by a root asset like your calendar, which never updates) to enable more things that people currently do via freshness-based scheduling. For example, putting limits on how many materializations a given asset can have in a given hour. Mind saying a bit more about how you'd like your AMPs to function?Nikolaj Galak
08/12/2023, 7:17 PMAutoMaterializePolicy(
on_missing=True,
on_new_parent_data=False,
for_freshness=False)
owen
08/14/2023, 8:27 PMShangwei Wang
08/14/2023, 8:42 PMlazy
(including all the models along the way), one of the downstream model has a pretty low freshness policy, say 10min for example. So i’m curious if i can save some building time from eliminating the re-build of this built-in model, by say, tricking the downstream models to see this built-in model as “always fresh”?owen
08/15/2023, 4:54 PMShangwei Wang
08/15/2023, 4:59 PMowen
08/15/2023, 10:12 PM