schema-discovery
Installation
SKILL.md
Schema Discovery
Table of Contents
| Task | Reference | Notes |
|---|---|---|
| Must/Prefer/Avoid | SKILL.md: Must/Prefer/Avoid | Guardrails for schema discovery |
| Progressive Discovery Strategy | SKILL.md: Progressive Schema Discovery | Decision tree for on-demand metadata fetching |
| Recommended Discovery Order | SKILL.md: Recommended Discovery Order | Start with scope estimation → tables → columns → measures → relationships |
| Metadata Object → INFO Function Map | SKILL.md: Metadata Object → INFO Function Map | Tables, columns, measures, relationships, calc groups, calendars, UDFs, variations |
| Scope Estimation Queries | discovery-queries.md: Scope Estimation Queries | Probe table/column/measure/relationship counts before deep discovery |
| INFO Output Columns | discovery-queries.md: INFO Output Columns | INFO.VIEW.* (read access); INFO.* (may need elevated access) |
| Narrowing Results (Projection + Filtering) | discovery-queries.md: Narrowing Results | SELECTCOLUMNS + FILTER to reduce output volume |
| Advanced Metadata (Calc Groups, Calendars, UDFs) | discovery-queries.md: Advanced Metadata Queries | INFO.CALCULATIONGROUPS, INFO.CALENDARS, INFO.USERDEFINEDFUNCTIONS, INFO.VARIATIONS |
| Complete INFO Function Catalog | discovery-queries.md: Complete INFO Function Catalog | Dynamic query to enumerate all INFO functions in the engine |