checking-freshness
Quick data freshness check. Use when the user asks if data is up to date, when a table was last updated, if data is stale, or needs to verify data currency before using it.
Install
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/checking-freshness ~/.claude/skills/checking-freshnessFrom README
Data Freshness Check Quickly determine if data is fresh enough to use. Freshness Check Process For each table to check: Find the Timestamp Column Look for columns that indicate when data was loaded or updated: loadedat, updatedat, createdat (common ETL patterns) updatedat, createdat, modifiedat (application timestamps) loaddate, etltimestamp, ingestiontime date, eventdate, transactiondate (business dates) Query INFORMATIONSCHEMA.COLUMNS if you need to see column names. Query Last Update Time Check Row Counts by Time For tables with regular updates, check recent activity: Freshness Status Report status using this scale: | Status | Age | Meaning | |--------|-----|---------| | Fresh | 24 hours | Likely a problem unless batch job | | Unknown | No timestamp | Can't determine freshness | If Data is Stale Check Airflow for the source pipeline: Find the DAG: Which DAG populates this table? Use af dags list and look for matching names. Check DAG status: Is the DAG paused?
More from this repo
airflow-state-store
Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores...
authoring-go-sdk-tasks
Writes Airflow task logic in Go using the Airflow Go SDK.
authoring-java-sdk-tasks
Writes Airflow task logic in Java, Kotlin, or any JVM language using the Airflow Java SDK.