# checking-freshness

> Claude/Codex skill by [@astronomer](https://omgskills.com/library/astronomer/index.md) · 454 stars · Updated 2026-10-14

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.

Tags: agentic-workflow, agents, ai, ai-agents, airflow, apache-airflow, claude, cursor, dag, data-engineering, data-pipelines, dbt, llm, mcp, orchestrator, skills, workflow-automation, workflow-management, workflow-orchestration, workflows

## Install

```sh
git clone https://github.com/astronomer/agents /tmp/agents && ln -s /tmp/agents/skills/checking-freshness ~/.claude/skills/checking-freshness
```

## From 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?

## Links

- HTML page: https://omgskills.com/skills/astronomer/agents/checking-freshness/
- GitHub: https://github.com/astronomer/agents
- Author: [@astronomer](https://omgskills.com/library/astronomer/index.md)

## More from this repo

- [airflow-state-store](https://omgskills.com/skills/astronomer/agents/skills/airflow-state-store/index.md) — Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores...
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars
- [authoring-go-sdk-tasks](https://omgskills.com/skills/astronomer/agents/skills/authoring-go-sdk-tasks/index.md) — Writes Airflow task logic in Go using the Airflow Go SDK.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars
- [authoring-java-sdk-tasks](https://omgskills.com/skills/astronomer/agents/skills/authoring-java-sdk-tasks/index.md) — Writes Airflow task logic in Java, Kotlin, or any JVM language using the Airflow Java SDK.
   - [@astronomer](https://omgskills.com/library/astronomer/index.md) · 456 stars