Hi, I would like to check the freshness of some ta...
# community-support
s
Hi, I would like to check the freshness of some tables, but the elementary.freshness_anomalies tests do a different check than I expected, calculating the difference between adjacent data. Is there any way to configure a test that goes to check, for example, that the previous day's data has been loaded, without having to write a custom dbt test? An operation similar to dbt's freshness checks:
Copy code
freshness: 
  error_after: {count: 24, period: hour}
  filter: modifiedon > DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY)
  loaded_at_field: "CAST(modifiedon AS TIMESTAMP)"
o
Hey @Simone CAVALLERA, why dont you just use dbt's freshness checks?
s
Hi @Ofek Weiss, yes. I finally found the solution by mapping the dbt freshness test to elementary. Thank you.