checking-freshness

Name: checking-freshness
Availability: InStock
Author: Astronomer

Evaluate latest timestamps across tables and output structured freshness reports.

419|61|Updated Jan 13, 2026

Search Tags:#SQL #freshness #data-quality #timestamp #data-validation #information_schema

Ready to run

npx skills add https://github.com/astronomer/agents --skill checking-freshness

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: checking-freshness
Source: https://github.com/astronomer/agents/tree/main/skills/checking-freshness
Command: npx skills add https://github.com/astronomer/agents --skill checking-freshness

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps data teams quickly determine if data is up to date by evaluating timestamp columns, computing last update times, and assigning a freshness status to tables in a data warehouse.

Core Features & Use Cases

Detects the most recent timestamp in a table to determine freshness.
Generates a concise freshness report including last update time, age, and status.
Use Case: validate that a table feeding a dashboard has refreshed data before rendering the report.

Quick Start

Check the freshness of a table by running a targeted query against your warehouse and review the resulting status.

Frequently Asked Questions about checking-freshness

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I check data freshness in a SQL data warehouse?▼

Data freshness validates that dashboard tables have updated data before rendering reports by detecting the most recent timestamp, computing data age, and assigning an up-to-date status to prevent stale insights.

How do I validate data freshness before running BI pipelines?▼

Can I perform ad-hoc freshness checks on tables with regular updates?▼

The skill computes data freshness by evaluating common timestamp columns across tables to calculate the last_update time, measure the age of the data, and output a structured status report.

How does timestamp detection work for data validation?▼

The skill computes data freshness by evaluating common timestamp columns across tables to calculate the last_update time, measure the age of the data, and output a structured status report.

What is the best way to generate a freshness report for data quality?▼

The best way to generate a freshness report is to query timestamp columns to identify the last update, calculate the age of the records, and output a structured data validation status.