Hi Does the `FreshnessPolicy` amp `build asset reconciliatio

Question

Hi Does the `FreshnessPolicy` amp `build asset reconciliation sensor` as outlined apply to dbt Cloud assets I m aware that if you select individual assets to materialize Dagster will override the dbt cloud job with that selection so I m wondering Dagster takes the same approach with freshness and reconciliation E g a non dbt cloud asset A is stale and dbt cloud asset B is dependent on A Asset B has dbt children C amp D but dbt cloud job also has E F and G which has no dependencies Will the reconciliation sensor and FreshnessPolicy work and result in Dagster triggering a dbt build for only B C and D <https docs dagster io guides dagster scheduling assets>

owen · Answer

Hi < Jason> because dbt Cloud assets now support subsetting the sensor should work as you re expecting i e only kicking off runs of the assets required to meet the freshness policy slightly smiling face

Jason · Answer

Awesome Thanks for the clarification

Jason · Answer

< owen> Am I correct to assume that although the sensor would work via other criteria I can t actually apply a FreshnessPolicy to dbt Cloud assets as there s doesn t seem to be support for this in `load assets from dbt cloud job` Example ``` asset freshness policy=FreshnessPolicy maximum lag minutes=20 ```

owen · Answer

ah yep that s right working on adding support for that either this week or next the current plan is to add a new parameter to the `load assets from ` command which will allow you to either supply a constant freshness policy which will be applied to all loaded models or a function that takes in a dictionary of node metadata and returns a freshness policy i e `lambda node info FreshnessPolicy maximum lag minutes=20 if node info name == model i care about else None`

owen · Answer

would that work for your use case

Jason · Answer

Yup that would work

Jonathan Neo · Answer

< owen> would this be the same for `load assets from dbt project` too

Jonathan Neo · Answer

Also whilst waiting for this feature to be available in `load assets from ` is there a way to do it by applying freshnessPolicy directly on the assets returned from `dbt assets = load assets from dbt project `

Jonathan Neo · Answer

Heya for anyone wondering this feature has been implemented in dagster version `1 1 7` To enable freshness policy for a selected dbt model you ll just have to add the following line of config to your dbt model ``` file my model sql config dagster freshness policy= maximum lag minutes 60 cron schedule 0 9 select from ref my table ``` More here <https github com dagster io dagster issues 10924>