get_table_schema
Get the full column schema for a specific table, including AEMO-published metadata: per-column description, units, valid enum values, primary-key flags, and available_from (the MMSDM release month a column was added — present only for late-added columns like 1-second FCAS RRPs; don't query those for earlier dates). Also returns table-level documentation (description, source/volume notes, package id) and a curated selector block carrying the hard-learnt caveats, grain, join_keys, related_tables, and question_tags — read the caveats before composing SQL. Pass the exact object_name from list_tables. Use this once you've picked a table; for cross-table column lookup use search_columns.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table_name": "<table_name>"
},
"name": "get_table_schema"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | Fully-qualified table name, e.g. `consolidated.dispatch__dispatch__unit_solution` or `semantic.duid_fuel_type`. Use the exact `object_name` from `list_tables`. | |
| question_id | No | Optional UUID returned by an earlier `start_question` call. When provided, this tool call is attributed to that question. |