Query staged POWER observations
nasa_power_dataframe_queryRun one read-only SELECT over tables in an explicitly supplied canvas_id. Inspect names and units with nasa_power_dataframe_describe. External files, imports, writes and system catalogs are refused. Returns at most 1,000 rows and 40,000 JSON characters; truncated rowCount counts only materialized rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | One read-only SELECT, at most 16,384 characters | |
| rowLimit | No | Positive maximum row count; values above 1,000 use an effective cap of 1,000 | |
| canvas_id | Yes | Canvas token returned by a producing POWER tool |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | JSON-safe projected values | |
| error | No | Present when the call failed. Absent on success. | |
| notice | No | Effective output row cap when the requested limit is larger | |
| columns | No | Projected SQL column names | |
| rowCount | No | Number of materialized rows; capped when truncated | |
| canvas_id | No | Explicit canvas capability token | |
| truncated | No | Whether additional result rows exist | |
| shownCount | No | Rows shown in this response | |
| countSemantics | No | Meaning of rowCount |