Data Freshness Check

Quickly determine if data is fresh enough to use.

Freshness Check Process

For each table to check:

1. Find the Timestamp Column

Look for columns that indicate when data was loaded or updated:

• _loaded_at, _updated_at, _created_at (common ETL patterns)
• updated_at, created_at, modified_at (application timestamps)
• load_date, etl_timestamp, ingestion_time
• date, event_date, transaction_date (business dates)

Query INFORMATION_SCHEMA.COLUMNS if you need to see column names.

2. Query Last Update Time