openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=DescribeClusterDbRevisions 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=DescribeClusterDbRevisions' paths: /#Action=DescribeClusterDbRevisions: 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: DescribeClusterDbRevisions operationId: GET_DescribeClusterDbRevisions description: Returns an array of ClusterDbRevision objects. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterDbRevisionsMessage' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' parameters: - name: ClusterIdentifier in: query required: false description: A unique identifier for a cluster whose ClusterDbRevisions you are requesting. This parameter is case sensitive. All clusters defined for an account are returned by default. schema: type: string maxLength: 2147483647 - name: MaxRecords in: query required: false description: '

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in the marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the marker parameter and retrying the request.

Default: 100

Constraints: minimum 20, maximum 100.

' schema: type: integer - name: Marker in: query required: false description: '

An optional parameter that specifies the starting point for returning a set of response records. When the results of a DescribeClusterDbRevisions request exceed the value specified in MaxRecords, Amazon Redshift returns a value in the marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the marker parameter and retrying the request.

Constraints: You can specify either the ClusterIdentifier parameter, or the marker parameter, but not both.

' schema: type: string maxLength: 2147483647 - name: Action in: query required: true schema: type: string enum: - DescribeClusterDbRevisions - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Describe Cluster Db Revisions x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeClusterDbRevisions' post: x-aws-operation-name: DescribeClusterDbRevisions operationId: POST_DescribeClusterDbRevisions description: Returns an array of ClusterDbRevision objects. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterDbRevisionsMessage' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' requestBody: content: text/xml: schema: $ref: '#/components/schemas/DescribeClusterDbRevisionsMessage' parameters: - name: MaxRecords in: query schema: type: string description: Pagination limit required: false - name: Marker in: query schema: type: string description: Pagination token required: false - name: Action in: query required: true schema: type: string enum: - DescribeClusterDbRevisions - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Describe Cluster Db Revisions x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeClusterDbRevisions' components: parameters: X-Amz-Credential: name: X-Amz-Credential in: header schema: type: string required: false X-Amz-SignedHeaders: name: X-Amz-SignedHeaders 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-Content-Sha256: name: X-Amz-Content-Sha256 in: header schema: type: string required: false X-Amz-Date: name: X-Amz-Date in: header schema: type: string required: false X-Amz-Signature: name: X-Amz-Signature in: header schema: type: string required: false X-Amz-Algorithm: name: X-Amz-Algorithm in: header schema: type: string required: false schemas: RevisionTargetsList: type: array items: allOf: - $ref: '#/components/schemas/RevisionTarget' - xml: name: RevisionTarget ClusterDbRevisionsList: type: array items: allOf: - $ref: '#/components/schemas/ClusterDbRevision' - xml: name: ClusterDbRevision IntegerOptional: type: integer TStamp: type: string format: date-time InvalidClusterStateFault: {} ClusterDbRevisionsMessage: type: object properties: Marker: allOf: - $ref: '#/components/schemas/String' - description: A string representing the starting point for the next set of revisions. If a value is returned in a response, you can retrieve the next set of revisions by providing the value in the marker parameter and retrying the command. If the marker field is empty, all revisions have already been returned. ClusterDbRevisions: allOf: - $ref: '#/components/schemas/ClusterDbRevisionsList' - description: A list of revisions. RevisionTarget: type: object properties: DatabaseRevision: allOf: - $ref: '#/components/schemas/String' - description: A unique string that identifies the version to update the cluster to. You can use this value in ModifyClusterDbRevision. Description: allOf: - $ref: '#/components/schemas/String' - description: A string that describes the changes and features that will be applied to the cluster when it is updated to the corresponding ClusterDbRevision. DatabaseRevisionReleaseDate: allOf: - $ref: '#/components/schemas/TStamp' - description: The date on which the database revision was released. description: Describes a RevisionTarget. DescribeClusterDbRevisionsMessage: type: object title: DescribeClusterDbRevisionsMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: A unique identifier for a cluster whose ClusterDbRevisions you are requesting. This parameter is case sensitive. All clusters defined for an account are returned by default. MaxRecords: allOf: - $ref: '#/components/schemas/IntegerOptional' - description: '

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in the marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the marker parameter and retrying the request.

Default: 100

Constraints: minimum 20, maximum 100.

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

An optional parameter that specifies the starting point for returning a set of response records. When the results of a DescribeClusterDbRevisions request exceed the value specified in MaxRecords, Amazon Redshift returns a value in the marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the marker parameter and retrying the request.

Constraints: You can specify either the ClusterIdentifier parameter, or the marker parameter, but not both.

' ClusterNotFoundFault: {} ClusterDbRevision: type: object properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The unique identifier of the cluster. CurrentDatabaseRevision: allOf: - $ref: '#/components/schemas/String' - description: A string representing the current cluster version. DatabaseRevisionReleaseDate: allOf: - $ref: '#/components/schemas/TStamp' - description: The date on which the database revision was released. RevisionTargets: allOf: - $ref: '#/components/schemas/RevisionTargetsList' - description: A list of RevisionTarget objects, where each object describes the database revision that a cluster can be updated to. description: Describes a ClusterDbRevision. String: type: string maxLength: 2147483647 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