vamseeachanta 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.)