---
title: "Estate Documentation Audit"
slug: "estate-documentation-audit"
type: recipe
locale: en-US
canonical: "https://www.coremodels.io/recipe/bigquery/estate-documentation-audit"
updatedAt: "2026-08-27T01:42:16+03:00"
---

# Estate Documentation Audit

Find every undocumented table and every ungoverned STRUCT/ARRAY/JSON payload.

The BigQuery connector reads the descriptions BigQuery already holds, COLUMN_FIELD_PATHS for columns, TABLE_OPTIONS for tables, into the governed model, and the recorded audit then names every gap on every run: undocumented tables and views (table-no-description) and columns whose STRUCT/ARRAY/JSON inner schemas are invisible to consumers and agents (semi-structured-column). The gaps stop being invisible, so they finally close, and the documentation you add in CoreModels can be generated back into the estate as OPTIONS(description=...) DDL.

## Articles

- [The First Thing You Notice Is What Stops Happening](https://www.coremodels.io/connector/bigquery/h2-outcomes)
- [A Complete Answer That Tells You Nothing: The BigQuery Metadata Problem](https://www.coremodels.io/connector/bigquery/h1-need)
- [Inside the BigQuery Connector: How an Estate Becomes a Governed Graph](https://www.coremodels.io/connector/bigquery/t5-deep-dive)