skills.rest
astronomer
astronomerOFFICIAL
Explore all skills by this author →
WebsiteGitHub

checking-freshness

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
One-click install
npx skills add https://github.com/astronomer/agents --skill checking-freshness
Or copy as Structured Prompt for Agent▼
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?▼

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.

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.

Related Skills

Explore More Data & Analytics Skills→
BfdCamposBfdCampos

bigquery

Query BigQuery INFORMATION_SCHEMA tables and columns for metadata without exposing data.

Community
Intermediate
timequitytimequity
6

pipeline-design

Design ETL/ELT pipeline architectures for batch and streaming data integration.

Official
Advanced
timequitytimequity
6

data-quality

Detect data quality issues in dbt and Great Expectations pipelines.

Official
Advanced
GhostOf0daysGhostOf0days

data-mining-ai-trading

Automates data mining for AI trading workflows with schema, freshness, and lineage tracking.

Community
Advanced