check_table_freshness
Report when tables were last written to catch stale or dead sources and avoid querying outdated data.
Instructions
Report when tables were last written, to catch stale or dead sources.
Several plausible-looking tables on this platform stopped being updated without being dropped, so a query against one silently returns old data. Check before trusting a table you have not used before.
Free — reads table metadata only, scanning no data.
Args: dataset_id: The dataset to check, e.g. "events_raw". table_id: A single table to check. Omit to report every table in the dataset, which is the faster way to spot a dead one. environment: Which configured BigQuery environment to use. Omit to use the default. Call list_environments to see what exists.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_id | No | ||
| dataset_id | Yes | ||
| environment | No |