How do I exclude a table from a freshness snapshot?
Some tables in a data source may be updated infrequently. If you've set a freshness
property at the source level, this table is likely to fail checks.
To work around this, you can set the table's freshness to null (freshness: null
) to "unset" the freshness for a particular table:
models/<filename>.yml
version: 2
sources:
- name: jaffle_shop
database: raw
freshness:
warn_after: {count: 12, period: hour}
error_after: {count: 24, period: hour}
loaded_at_field: _etl_loaded_at
tables:
- name: orders
- name: product_skus
freshness: null # do not check freshness for this table
0