For Table Documentation (+2)

For Table Documentation

• Location: Full table path
• Description: What this table contains, when to use it
• Primary Key: How to uniquely identify rows
• Update Frequency: How often data refreshes
• Key Columns: Table with column name, type, description, notes
• Relationships: How this table joins to others
• Sample Queries: 2-3 common query patterns

For Metrics Documentation

• Metric Name: Human-readable name
• Definition: Plain English explanation
• Formula: Exact calculation with column references
• Source Table(s): Where the data comes from
• Caveats: Edge cases, exclusions, gotchas

For Entity Documentation

• Entity Name: What it's called
• Definition: What it represents in the business
• Primary Table: Where to find this entity
• ID Field(s): How to identify it
• Relationships: How it relates to other entities
• Common Filters: Standard exclusions (internal, test, etc.)