freshness

Identify stale data across configured tables in data warehouses and ETL pipelines.

209|30|Updated Sep 18, 2021
One-click install
npx skills add https://github.com/starlake-ai/starlake --skill freshness
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: freshness
Source: https://github.com/starlake-ai/starlake/tree/main/.agent/skills/freshness
Command: npx skills add https://github.com/starlake-ai/starlake --skill freshness

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data engineers and analysts often rely on stale data that undercuts trust and decision making. This Skill provides a quick way to verify that important tables are fresh according to defined thresholds.

Core Features & Use Cases

  • Check freshness across a selected set of tables
  • Integrate with existing data quality dashboards to surface staleness
  • Use during scheduled runs to alert on stale data

Quick Start

Run starlake freshness to identify stale tables and surface freshness metrics for your configured datasets.

Frequently Asked Questions about freshness

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

FAQPage Schema
How do I check data freshness and identify stale tables in my data warehouse?▼

You can verify data freshness by running a command that checks configured tables against defined timeliness thresholds. This identifies stale data in your data warehouse and surfaces staleness metrics for monitoring.

Can I integrate data freshness checks into scheduled ETL pipelines?▼

Yes, you can integrate data freshness checks into scheduled ETL pipelines. Running timeliness verification during pipeline execution alerts you to stale data, ensuring downstream datasets remain current for decision making.

What is data timeliness verification and when do I need it for data quality?▼

Data timeliness verification confirms that tables are updated within expected timeframes. You need it in data warehouses and ETL pipelines to prevent reliance on stale data, maintaining trust and data quality.

Does the freshness check support filtering specific tables and persisting results?▼

Yes, freshness checks support CLI options for table filtering and result persistence. You can customize checks for specific connections and store the freshness results to integrate with existing data quality dashboards.

What is the best way to monitor data staleness across multiple datasets?▼

The best way to monitor data staleness across multiple datasets is applying a freshness verification check across environments. This surfaces stale tables and integrates metrics into existing data quality dashboards.