Describe a warehouse view
describe_viewCheck which columns and SQL types a warehouse view contains before writing queries. Avoid errors by referencing only existing columns; misspelled names return close matches.
Instructions
Return the column names and SQL types of ONE warehouse view. Take the exact view name from list_views, and call this before writing a query so you only reference columns that exist. Source is the live INFORMATION_SCHEMA (bundled snapshot as fallback; the 'source' field says which). On an unknown or misspelled name it returns found=false plus the closest matching view names as suggestions - retry with one of those. Traps: wh_task holds BOTH tickets and project tasks (a ticket has project_id IS NULL); time is split across wh_time_item (header, carries task_id) and wh_time_subitem (the hours), joined on time_item_id. See warehouse://guide for the ID-resolution map that turns *_id columns into names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| view | Yes | Exact view name from list_views, e.g. "wh_task", "wh_account", "wh_posted_overall". |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| hint | No | ||
| view | No | ||
| found | Yes | ||
| source | No | ||
| columns | No | ||
| suggestions | No |