describe_object
Returns full DDL for a table or view when compact schema details are insufficient, respecting caller roles and principal so restricted objects stay hidden.
Instructions
Full DDL (all visible columns, keys, comments) for one table or view, if the caller may read it. Use it when select_schema's compact DDL is not enough. A restricted or missing object returns the same 'not available' error, so its existence is not revealed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Table or view name as returned by select_schema or list_objects, bare ('orders') or schema-qualified ('sales.orders'). | |
| roles | No | The caller's roles or groups, e.g. ['finance', 'payroll']. Objects and columns restricted to a role are visible only when it is listed here. Omitted = no roles. | |
| principal | No | Who is asking, as an identity string such as 'okta:jdoe'. Pass it whenever you know the user: visibility is decided for this identity. Omitted = anonymous, which sees only unrestricted objects. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |