1. Identify the table(s) to check for freshness.
2. Find relevant timestamp columns (e.g., `_loaded_at`, `updated_at`).
3. Query the maximum timestamp value for each table.
4. Calculate the age of the data (time since last update).
5. Determine freshness status based on the age (Fresh, Stale, Very Stale, Unknown).
6. If stale, check Airflow for the source DAG status.
7. Report the freshness status and any recommended actions.
SynapticSkills