Agents Lookup

Use cases / Data & analytics

Draft table and column descriptions for the data catalog

Generate descriptions for undocumented tables and columns from their schema and data, then have owners edit and approve them.

DifficultyBeginner
Setup time1-2 hours
CategoryData & analytics

The use case

Data catalogs are only useful if tables have descriptions, and most do not. Databricks can generate AI comments for Unity Catalog tables and columns from metadata, and BigQuery's data insights can draft descriptions for Dataplex. The owner reviews each draft, corrects business meaning, and saves it. Better descriptions also improve text-to-SQL tools that rely on them. Owners should not bulk-accept drafts; a confident wrong description is worse than none because people trust it. Teams usually start with the most-queried tables, since those descriptions get read most and help the most people.

Example workflow

  1. List tables with missing descriptions
  2. Generate draft comments
  3. Owner edits and approves each one
  4. Save to the catalog
  5. Re-check when schemas change

Tools

Risks and guardrails

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: