describe
Inspect one table to get its grain, column types, units, cited definitions, manifest readers, and first five grain-sorted rows after search_catalog names it.
Instructions
Describe one table: its grain, every column with its type, unit and definition (cited to the build's definitions file where one exists), the manifest figures that read it, and its first five rows sorted by the grain. Call it for one table at a time, after search_catalog has named the table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| warehouse | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| grain | Yes | ||
| table | Yes | ||
| columns | Yes | ||
| examples | Yes | the first five rows sorted by the grain | |
| statement | No | Answers are drawn from the published tables of three portfolio builds by Ajay Mekala: doorstep (public housing data from FHFA, the Census Bureau, HUD, the CFPB and Freddie Mac), turnaround (public flight data from the Bureau of Transportation Statistics, the FAA and OurAirports, with weather from Open-Meteo under CC BY 4.0) and ledger (a fictional bank, Harborline, with public HMDA, CFPB, FDIC and macro series). No person appears in any table, and questions are redacted before a model sees them. Every number is read back to the warehouse before it is shown. This is a portfolio demonstration, not financial, travel or lending advice. | |
| warehouse | Yes | ||
| source_step | Yes | ||
| manifest_keys | Yes |