check_health
Assess whether a data table is safe to rely on using freshness, row-count trends, null rates, and dbt test results. Receive a one-line verdict indicating deprecated or failing status for user warning.
Instructions
Check whether a table is safe to rely on right now.
Call this before presenting any number derived from a table you have not already checked, and whenever a user mentions a table you did not choose yourself. Reports freshness, row-count movement, null rates, and dbt test results, plus a one-line verdict. A verdict of "deprecated" or "failing" means you should warn the user before using the table, not silently proceed.
Args: table: Table name, fully qualified or bare.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | No | ||
| table | Yes | ||
| tests | No | ||
| summary | Yes | One line a human can act on | |
| verdict | Yes | ||
| row_count | No | ||
| checked_at | No | ||
| null_rates | No | Column name -> percentage of NULL values | |
| freshness_hours | No | Hours since the most recent event in the table | |
| row_count_delta_7d | No | ||
| max_event_timestamp | No |