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 aResizeCluster 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}}".
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.
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