Amazon Redshift · Schema
ExecuteStatementRequest
AnalyticsBig DataCloudData LakeData WarehouseETLMachine-LearningServerlessSQL
Properties
| Name | Type | Description |
|---|---|---|
| ClusterIdentifier | string | The cluster identifier. Required when connecting to a provisioned cluster. Mutually exclusive with WorkgroupName. |
| Database | string | The name of the database to run the SQL statement against |
| DbUser | string | The database user name. Required when authenticating with temporary credentials from GetClusterCredentials. |
| SecretArn | string | The ARN of the secret stored in AWS Secrets Manager that contains the database credentials. Mutually exclusive with DbUser and temporary credentials. |
| Sql | string | The SQL statement to run. Maximum length is 100,000 characters. |
| StatementName | string | A name for the SQL statement. This name can be used to identify the query in the ListStatements output. |
| WithEvent | boolean | Whether to send an event to Amazon EventBridge when the SQL statement completes. Default is false. |
| WorkgroupName | string | The serverless workgroup name. Required when connecting to Redshift Serverless. Mutually exclusive with ClusterIdentifier. |
| Parameters | array | Named parameters for the SQL statement. Use :name syntax in the SQL string to reference parameters. |
| ClientToken | string | A unique, case-sensitive identifier to ensure idempotency of the request. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"title": "ExecuteStatementRequest",
"type": "object",
"properties": {
"ClusterIdentifier": {
"type": "string",
"description": "The cluster identifier. Required when connecting to a provisioned cluster. Mutually exclusive with WorkgroupName."
},
"Database": {
"type": "string",
"description": "The name of the database to run the SQL statement against"
},
"DbUser": {
"type": "string",
"description": "The database user name. Required when authenticating with temporary credentials from GetClusterCredentials."
},
"SecretArn": {
"type": "string",
"description": "The ARN of the secret stored in AWS Secrets Manager that contains the database credentials. Mutually exclusive with DbUser and temporary credentials."
},
"Sql": {
"type": "string",
"description": "The SQL statement to run. Maximum length is 100,000 characters."
},
"StatementName": {
"type": "string",
"description": "A name for the SQL statement. This name can be used to identify the query in the ListStatements output."
},
"WithEvent": {
"type": "boolean",
"description": "Whether to send an event to Amazon EventBridge when the SQL statement completes. Default is false."
},
"WorkgroupName": {
"type": "string",
"description": "The serverless workgroup name. Required when connecting to Redshift Serverless. Mutually exclusive with ClusterIdentifier."
},
"Parameters": {
"type": "array",
"description": "Named parameters for the SQL statement. Use :name syntax in the SQL string to reference parameters."
},
"ClientToken": {
"type": "string",
"description": "A unique, case-sensitive identifier to ensure idempotency of the request."
}
}
}
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-execute-statement-request"
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.