AgileData.io Docs
Table Of Contents
AgileData.io Docs
Table Of Contents

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