describe_table
Get a table's full meaning—purpose, grain, owner, status, and columns—including critical unit details that distinguish gross from net and prevent guessing.
Instructions
Get the full meaning of one table: purpose, grain, owner, status, and columns.
Call this before using any table you have not already described in this
conversation. The column unit field is the part that matters most — it
distinguishes gross from net and cents from dollars, which the schema alone
cannot tell you. A unit of "unknown" means nobody documented it; say so
rather than guessing.
Args: table: Table name, fully qualified or bare (e.g. "main.fct_revenue_daily"). include_columns: Set False when you only need purpose, owner, and status.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| include_columns | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| grain | No | What one row represents, e.g. 'one row per customer per day' | |
| owner | No | ||
| status | No | active | |
| columns | No | ||
| purpose | Yes | ||
| row_count | No | ||
| truncated | No | True when the column list was cut to protect the context window | |
| last_updated | No | ||
| superseded_by | No | ||
| materialization | No | table, view, incremental, ... | |
| truncation_hint | No | How to retrieve the omitted columns when truncated is True |