openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=ModifyScheduledAction API' description:

You can use the Amazon Redshift Data API to run queries on Amazon Redshift tables. You can run SQL statements, which are committed if the statement succeeds.

For more information about the Amazon Redshift Data API and CLI usage examples, see Using the Amazon Redshift Data API in the Amazon Redshift Management Guide.

x-logo: url: https://api.apis.guru/v2/cache/logo/https_twitter.com_awscloud_profile_image.png backgroundColor: '#FFFFFF' termsOfService: https://aws.amazon.com/service-terms/ contact: name: Mike Ralphson email: mike.ralphson@gmail.com url: https://github.com/mermade/aws2openapi x-twitter: PermittedSoc license: name: Apache 2.0 License url: http://www.apache.org/licenses/ x-providerName: amazonaws.com x-serviceName: redshift-data x-aws-signingName: redshift-data x-origin: - contentType: application/json url: https://raw.githubusercontent.com/aws/aws-sdk-js/master/apis/redshift-data-2019-12-20.normal.json converter: url: https://github.com/mermade/aws2openapi version: 1.0.0 x-apisguru-driver: external x-apiClientRegistration: url: https://portal.aws.amazon.com/gp/aws/developer/registration/index.html?nc2=h_ct x-apisguru-categories: - cloud x-preferred: true servers: - url: http://redshift-data.{region}.amazonaws.com variables: region: description: The AWS region enum: - us-east-1 - us-east-2 - us-west-1 - us-west-2 - us-gov-west-1 - us-gov-east-1 - ca-central-1 - eu-north-1 - eu-west-1 - eu-west-2 - eu-west-3 - eu-central-1 - eu-south-1 - af-south-1 - ap-northeast-1 - ap-northeast-2 - ap-northeast-3 - ap-southeast-1 - ap-southeast-2 - ap-east-1 - ap-south-1 - sa-east-1 - me-south-1 default: us-east-1 description: The Redshift Data API Service multi-region endpoint - url: https://redshift-data.{region}.amazonaws.com variables: region: description: The AWS region enum: - us-east-1 - us-east-2 - us-west-1 - us-west-2 - us-gov-west-1 - us-gov-east-1 - ca-central-1 - eu-north-1 - eu-west-1 - eu-west-2 - eu-west-3 - eu-central-1 - eu-south-1 - af-south-1 - ap-northeast-1 - ap-northeast-2 - ap-northeast-3 - ap-southeast-1 - ap-southeast-2 - ap-east-1 - ap-south-1 - sa-east-1 - me-south-1 default: us-east-1 description: The Redshift Data API Service multi-region endpoint - url: http://redshift-data.{region}.amazonaws.com.cn variables: region: description: The AWS region enum: - cn-north-1 - cn-northwest-1 default: cn-north-1 description: The Redshift Data API Service endpoint for China (Beijing) and China (Ningxia) - url: https://redshift-data.{region}.amazonaws.com.cn variables: region: description: The AWS region enum: - cn-north-1 - cn-northwest-1 default: cn-north-1 description: The Redshift Data API Service endpoint for China (Beijing) and China (Ningxia) security: - hmac: [] tags: - name: '#Action=ModifyScheduledAction' paths: /#Action=ModifyScheduledAction: parameters: - $ref: '#/components/parameters/X-Amz-Content-Sha256' - $ref: '#/components/parameters/X-Amz-Date' - $ref: '#/components/parameters/X-Amz-Algorithm' - $ref: '#/components/parameters/X-Amz-Credential' - $ref: '#/components/parameters/X-Amz-Security-Token' - $ref: '#/components/parameters/X-Amz-Signature' - $ref: '#/components/parameters/X-Amz-SignedHeaders' get: x-aws-operation-name: ModifyScheduledAction operationId: GET_ModifyScheduledAction description: 'Modifies a scheduled action. ' responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ScheduledAction' '480': description: ScheduledActionNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ScheduledActionNotFoundFault' '481': description: ScheduledActionTypeUnsupportedFault content: text/xml: schema: $ref: '#/components/schemas/ScheduledActionTypeUnsupportedFault' '482': description: InvalidScheduleFault content: text/xml: schema: $ref: '#/components/schemas/InvalidScheduleFault' '483': description: InvalidScheduledActionFault content: text/xml: schema: $ref: '#/components/schemas/InvalidScheduledActionFault' '484': description: UnauthorizedOperation content: text/xml: schema: $ref: '#/components/schemas/UnauthorizedOperation' parameters: - name: ScheduledActionName in: query required: true description: 'The name of the scheduled action to modify. ' schema: type: string maxLength: 2147483647 - name: TargetAction in: query required: false description: 'A modified JSON format of the scheduled action. For more information about this parameter, see ScheduledAction. ' schema: type: object properties: ResizeCluster: allOf: - $ref: '#/components/schemas/ResizeClusterMessage' - description: 'An action that runs a ResizeCluster API operation. ' PauseCluster: allOf: - $ref: '#/components/schemas/PauseClusterMessage' - description: 'An action that runs a PauseCluster API operation. ' ResumeCluster: allOf: - $ref: '#/components/schemas/ResumeClusterMessage' - description: 'An action that runs a ResumeCluster API operation. ' description: 'The action type that specifies an Amazon Redshift API operation that is supported by the Amazon Redshift scheduler. ' - name: Schedule in: query required: false description: A modified schedule in either at( ) or cron( ) format. For more information about this parameter, see ScheduledAction. schema: type: string maxLength: 2147483647 - name: IamRole in: query required: false description: A different IAM role to assume to run the target action. For more information about this parameter, see ScheduledAction. schema: type: string maxLength: 2147483647 - name: ScheduledActionDescription in: query required: false description: 'A modified description of the scheduled action. ' schema: type: string maxLength: 2147483647 - name: StartTime in: query required: false description: 'A modified start time of the scheduled action. For more information about this parameter, see ScheduledAction. ' schema: type: string format: date-time - name: EndTime in: query required: false description: 'A modified end time of the scheduled action. For more information about this parameter, see ScheduledAction. ' schema: type: string format: date-time - name: Enable in: query required: false description: 'A modified enable flag of the scheduled action. If true, the scheduled action is active. If false, the scheduled action is disabled. ' schema: type: boolean - name: Action in: query required: true schema: type: string enum: - ModifyScheduledAction - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Modify Scheduled Action x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=ModifyScheduledAction' post: x-aws-operation-name: ModifyScheduledAction operationId: POST_ModifyScheduledAction description: 'Modifies a scheduled action. ' responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ScheduledAction' '480': description: ScheduledActionNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ScheduledActionNotFoundFault' '481': description: ScheduledActionTypeUnsupportedFault content: text/xml: schema: $ref: '#/components/schemas/ScheduledActionTypeUnsupportedFault' '482': description: InvalidScheduleFault content: text/xml: schema: $ref: '#/components/schemas/InvalidScheduleFault' '483': description: InvalidScheduledActionFault content: text/xml: schema: $ref: '#/components/schemas/InvalidScheduledActionFault' '484': description: UnauthorizedOperation content: text/xml: schema: $ref: '#/components/schemas/UnauthorizedOperation' requestBody: content: text/xml: schema: $ref: '#/components/schemas/ModifyScheduledActionMessage' parameters: - name: Action in: query required: true schema: type: string enum: - ModifyScheduledAction - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Modify Scheduled Action x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=ModifyScheduledAction' components: parameters: X-Amz-Credential: name: X-Amz-Credential in: header schema: type: string required: false X-Amz-Security-Token: name: X-Amz-Security-Token in: header schema: type: string required: false X-Amz-Date: name: X-Amz-Date in: header schema: type: string required: false X-Amz-Algorithm: name: X-Amz-Algorithm in: header schema: type: string required: false X-Amz-SignedHeaders: name: X-Amz-SignedHeaders in: header schema: type: string required: false X-Amz-Content-Sha256: name: X-Amz-Content-Sha256 in: header schema: type: string required: false X-Amz-Signature: name: X-Amz-Signature in: header schema: type: string required: false schemas: ScheduledActionNotFoundFault: {} ModifyScheduledActionMessage: type: object required: - ScheduledActionName title: ModifyScheduledActionMessage properties: ScheduledActionName: allOf: - $ref: '#/components/schemas/String' - description: 'The name of the scheduled action to modify. ' TargetAction: allOf: - $ref: '#/components/schemas/ScheduledActionType' - description: 'A modified JSON format of the scheduled action. For more information about this parameter, see ScheduledAction. ' Schedule: allOf: - $ref: '#/components/schemas/String' - description: A modified schedule in either at( ) or cron( ) format. For more information about this parameter, see ScheduledAction. IamRole: allOf: - $ref: '#/components/schemas/String' - description: A different IAM role to assume to run the target action. For more information about this parameter, see ScheduledAction. ScheduledActionDescription: allOf: - $ref: '#/components/schemas/String' - description: 'A modified description of the scheduled action. ' StartTime: allOf: - $ref: '#/components/schemas/TStamp' - description: 'A modified start time of the scheduled action. For more information about this parameter, see ScheduledAction. ' EndTime: allOf: - $ref: '#/components/schemas/TStamp' - description: 'A modified end time of the scheduled action. For more information about this parameter, see ScheduledAction. ' Enable: allOf: - $ref: '#/components/schemas/BooleanOptional' - description: 'A modified enable flag of the scheduled action. If true, the scheduled action is active. If false, the scheduled action is disabled. ' BooleanOptional: type: boolean TStamp: type: string format: date-time String: type: string maxLength: 2147483647 UnauthorizedOperation: {} ResumeClusterMessage: type: object required: - ClusterIdentifier title: ResumeClusterMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the cluster to be resumed. description: 'Describes a resume cluster operation. For example, a scheduled action to run the ResumeCluster API operation. ' ScheduledAction: type: object properties: ScheduledActionName: allOf: - $ref: '#/components/schemas/String' - description: 'The name of the scheduled action. ' TargetAction: allOf: - $ref: '#/components/schemas/ScheduledActionType' - description:

A JSON format string of the Amazon Redshift API operation with input parameters.

"{\"ResizeCluster\":{\"NodeType\":\"ds2.8xlarge\",\"ClusterIdentifier\":\"my-test-cluster\",\"NumberOfNodes\":3}}".

Schedule: allOf: - $ref: '#/components/schemas/String' - description:

The schedule for a one-time (at format) or recurring (cron format) scheduled action. Schedule invocations must be separated by at least one hour.

Format of at expressions is "at(yyyy-mm-ddThh:mm:ss)". For example, "at(2016-03-04T17:27:00)".

Format of cron expressions is "cron(Minutes Hours Day-of-month Month Day-of-week Year)". For example, "cron(0 10 ? * MON *)". For more information, see Cron Expressions in the Amazon CloudWatch Events User Guide.

IamRole: allOf: - $ref: '#/components/schemas/String' - description: 'The IAM role to assume to run the scheduled action. This IAM role must have permission to run the Amazon Redshift API operation in the scheduled action. This IAM role must allow the Amazon Redshift scheduler (Principal scheduler.redshift.amazonaws.com) to assume permissions on your behalf. For more information about the IAM role to use with the Amazon Redshift scheduler, see Using Identity-Based Policies for Amazon Redshift in the Amazon Redshift Cluster Management Guide. ' ScheduledActionDescription: allOf: - $ref: '#/components/schemas/String' - description: 'The description of the scheduled action. ' State: allOf: - $ref: '#/components/schemas/ScheduledActionState' - description: 'The state of the scheduled action. For example, DISABLED. ' NextInvocations: allOf: - $ref: '#/components/schemas/ScheduledActionTimeList' - description: 'List of times when the scheduled action will run. ' StartTime: allOf: - $ref: '#/components/schemas/TStamp' - description: 'The start time in UTC when the schedule is active. Before this time, the scheduled action does not trigger. ' EndTime: allOf: - $ref: '#/components/schemas/TStamp' - description: 'The end time in UTC when the schedule is no longer active. After this time, the scheduled action does not trigger. ' description: 'Describes a scheduled action. You can use a scheduled action to trigger some Amazon Redshift API operations on a schedule. For information about which API operations can be scheduled, see ScheduledActionType. ' ScheduledActionState: type: string enum: - ACTIVE - DISABLED PauseClusterMessage: type: object required: - ClusterIdentifier title: PauseClusterMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the cluster to be paused. description: 'Describes a pause cluster operation. For example, a scheduled action to run the PauseCluster API operation. ' ResizeClusterMessage: type: object required: - ClusterIdentifier title: ResizeClusterMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The unique identifier for the cluster to resize. ClusterType: allOf: - $ref: '#/components/schemas/String' - description: The new cluster type for the specified cluster. NodeType: allOf: - $ref: '#/components/schemas/String' - description: The new node type for the nodes you are adding. If not specified, the cluster's current node type is used. NumberOfNodes: allOf: - $ref: '#/components/schemas/IntegerOptional' - description: The new number of nodes for the cluster. If not specified, the cluster's current number of nodes is used. Classic: allOf: - $ref: '#/components/schemas/BooleanOptional' - description: 'A boolean value indicating whether the resize operation is using the classic resize process. If you don''t provide this parameter or set the value to false, the resize type is elastic. ' ReservedNodeId: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the reserved node. TargetReservedNodeOfferingId: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the target reserved node offering. description: 'Describes a resize cluster operation. For example, a scheduled action to run the ResizeCluster API operation. ' ScheduledActionType: type: object properties: ResizeCluster: allOf: - $ref: '#/components/schemas/ResizeClusterMessage' - description: 'An action that runs a ResizeCluster API operation. ' PauseCluster: allOf: - $ref: '#/components/schemas/PauseClusterMessage' - description: 'An action that runs a PauseCluster API operation. ' ResumeCluster: allOf: - $ref: '#/components/schemas/ResumeClusterMessage' - description: 'An action that runs a ResumeCluster API operation. ' description: 'The action type that specifies an Amazon Redshift API operation that is supported by the Amazon Redshift scheduler. ' InvalidScheduledActionFault: {} InvalidScheduleFault: {} ScheduledActionTypeUnsupportedFault: {} IntegerOptional: type: integer ScheduledActionTimeList: type: array items: allOf: - $ref: '#/components/schemas/TStamp' - xml: name: ScheduledActionTime securitySchemes: hmac: type: apiKey name: Authorization in: header description: Amazon Signature authorization v4 x-amazon-apigateway-authtype: awsSigv4 externalDocs: description: Amazon Web Services documentation url: https://docs.aws.amazon.com/redshift-data/ x-hasEquivalentPaths: true