2026-11-11 - Daily Housekeeping Tidies Up Leftovers Automatically¶
Release¶
AgileData.io - A Self-Tidying Tenancy: Smarter Daily Housekeeping
Over time, a tenancy collects leftovers: records of tables that were dropped long ago, views left pointing at deleted tiles, and failed trust results for tables or rules that no longer exist. They clutter your trust results and make health findings look worse than things really are.
Daily housekeeping now cleans these up. It keeps AgileData’s record of your tables in step with what is actually in BigQuery. It removes trust results for tables, columns or tile rules that have gone. It removes the views left behind when you deliberately delete a tile or rule. Each step only removes something when the record shows it was removed on purpose and nothing still depends on it.
Housekeeping also now finds orphan tables: tables nothing references and nobody has read for 30 days. For now it only reports them, showing a drop, wait or keep verdict on each finding in Tenancy Health, without dropping anything. The Tenancy Health check runs straight after housekeeping each day, so it reports on the tidied state.
What’s New:
AgileData’s table records reconciled with BigQuery every day
Orphaned trust results cleared automatically
Broken views left by deliberately deleted tiles and rules removed
Orphan tables identified and reported, with a verdict for each
Tenancy Health runs every day after housekeeping
What this means for you:
Trust results and health findings that reflect your current data
Less clutter to investigate by hand
Tables that might still hold valuable data are reported for you to decide on, never removed silently
Last Refreshed¶
Doc Refreshed: 2026-11-13