Amazon Redshift · Schema
SubStatementData
AnalyticsBig DataCloudData LakeData WarehouseETLMachine-LearningServerlessSQL
Properties
| Name | Type | Description |
|---|---|---|
| Id | string | The identifier of the sub-statement |
| Status | string | The status of the sub-statement |
| CreatedAt | string | The date and time the sub-statement was created |
| UpdatedAt | string | The date and time the sub-statement was last updated |
| Duration | integer | The time in nanoseconds the sub-statement ran |
| QueryString | string | The SQL statement text |
| RedshiftQueryId | integer | The Redshift query identifier |
| ResultRows | integer | Total number of rows in the result set |
| ResultSize | integer | The size of the result set in bytes |
| HasResultSet | boolean | Whether the sub-statement has a result set |
| Error | string | The error message if the sub-statement failed |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "SubStatementData",
"type": "object",
"properties": {
"Id": {
"type": "string",
"description": "The identifier of the sub-statement"
},
"Status": {
"type": "string",
"description": "The status of the sub-statement"
},
"CreatedAt": {
"type": "string",
"description": "The date and time the sub-statement was created"
},
"UpdatedAt": {
"type": "string",
"description": "The date and time the sub-statement was last updated"
},
"Duration": {
"type": "integer",
"description": "The time in nanoseconds the sub-statement ran"
},
"QueryString": {
"type": "string",
"description": "The SQL statement text"
},
"RedshiftQueryId": {
"type": "integer",
"description": "The Redshift query identifier"
},
"ResultRows": {
"type": "integer",
"description": "Total number of rows in the result set"
},
"ResultSize": {
"type": "integer",
"description": "The size of the result set in bytes"
},
"HasResultSet": {
"type": "boolean",
"description": "Whether the sub-statement has a result set"
},
"Error": {
"type": "string",
"description": "The error message if the sub-statement failed"
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/amazon-redshift-data-sub-statement-data"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.