openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=ModifyEventSubscription 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=ModifyEventSubscription' paths: /#Action=ModifyEventSubscription: 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: ModifyEventSubscription operationId: GET_ModifyEventSubscription description: Modifies an existing Amazon Redshift event notification subscription. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ModifyEventSubscriptionResult' '480': description: SubscriptionNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SubscriptionNotFoundFault' '481': description: SNSInvalidTopicFault content: text/xml: schema: $ref: '#/components/schemas/SNSInvalidTopicFault' '482': description: SNSNoAuthorizationFault content: text/xml: schema: $ref: '#/components/schemas/SNSNoAuthorizationFault' '483': description: SNSTopicArnNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SNSTopicArnNotFoundFault' '484': description: SubscriptionEventIdNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SubscriptionEventIdNotFoundFault' '485': description: SubscriptionCategoryNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SubscriptionCategoryNotFoundFault' '486': description: SubscriptionSeverityNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SubscriptionSeverityNotFoundFault' '487': description: SourceNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/SourceNotFoundFault' '488': description: InvalidSubscriptionStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidSubscriptionStateFault' parameters: - name: SubscriptionName in: query required: true description: The name of the modified Amazon Redshift event notification subscription. schema: type: string maxLength: 2147483647 - name: SnsTopicArn in: query required: false description: The Amazon Resource Name (ARN) of the SNS topic to be used by the event notification subscription. schema: type: string maxLength: 2147483647 - name: SourceType in: query required: false description: 'The type of source that will be generating the events. For example, if you want to be notified of events generated by a cluster, you would set this parameter to cluster. If this value is not specified, events are returned for all Amazon Redshift objects in your Amazon Web Services account. You must specify a source type in order to specify source IDs.
Valid values: cluster, cluster-parameter-group, cluster-security-group, cluster-snapshot, and scheduled-action.
' schema: type: string maxLength: 2147483647 - name: SourceIds in: query required: false description: 'A list of one or more identifiers of Amazon Redshift source objects. All of the objects must be of the same type as was specified in the source type parameter. The event subscription will return only events generated by the specified objects. If not specified, then events are returned for all objects within the source type specified.
Example: my-cluster-1, my-cluster-2
Example: my-snapshot-20131010
' schema: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: SourceId - name: EventCategories in: query required: false description: 'Specifies the Amazon Redshift event categories to be published by the event notification subscription.
Values: configuration, management, monitoring, security, pending
' schema: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: EventCategory - name: Severity in: query required: false description: 'Specifies the Amazon Redshift event severity to be published by the event notification subscription.
Values: ERROR, INFO
' schema: type: string maxLength: 2147483647 - name: Enabled in: query required: false description: 'A Boolean value indicating if the subscription is enabled.true indicates the subscription is enabled '
schema:
type: boolean
- name: Action
in: query
required: true
schema:
type: string
enum:
- ModifyEventSubscription
- name: Version
in: query
required: true
schema:
type: string
enum:
- '2012-12-01'
summary: Amazon Redshift - G E T_ Modify Event Subscription
x-microcks-operation:
delay: 0
dispatcher: FALLBACK
tags:
- '#Action=ModifyEventSubscription'
post:
x-aws-operation-name: ModifyEventSubscription
operationId: POST_ModifyEventSubscription
description: Modifies an existing Amazon Redshift event notification subscription.
responses:
'200':
description: Success
content:
text/xml:
schema:
$ref: '#/components/schemas/ModifyEventSubscriptionResult'
'480':
description: SubscriptionNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SubscriptionNotFoundFault'
'481':
description: SNSInvalidTopicFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SNSInvalidTopicFault'
'482':
description: SNSNoAuthorizationFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SNSNoAuthorizationFault'
'483':
description: SNSTopicArnNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SNSTopicArnNotFoundFault'
'484':
description: SubscriptionEventIdNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SubscriptionEventIdNotFoundFault'
'485':
description: SubscriptionCategoryNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SubscriptionCategoryNotFoundFault'
'486':
description: SubscriptionSeverityNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SubscriptionSeverityNotFoundFault'
'487':
description: SourceNotFoundFault
content:
text/xml:
schema:
$ref: '#/components/schemas/SourceNotFoundFault'
'488':
description: InvalidSubscriptionStateFault
content:
text/xml:
schema:
$ref: '#/components/schemas/InvalidSubscriptionStateFault'
requestBody:
content:
text/xml:
schema:
$ref: '#/components/schemas/ModifyEventSubscriptionMessage'
parameters:
- name: Action
in: query
required: true
schema:
type: string
enum:
- ModifyEventSubscription
- name: Version
in: query
required: true
schema:
type: string
enum:
- '2012-12-01'
summary: Amazon Redshift - P O S T_ Modify Event Subscription
x-microcks-operation:
delay: 0
dispatcher: FALLBACK
tags:
- '#Action=ModifyEventSubscription'
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:
SubscriptionCategoryNotFoundFault: {}
Tag:
type: object
properties:
Key:
allOf:
- $ref: '#/components/schemas/String'
- description: The key, or name, for the resource tag.
Value:
allOf:
- $ref: '#/components/schemas/String'
- description: The value for the resource tag.
description: A tag consisting of a name/value pair for a resource.
BooleanOptional:
type: boolean
TStamp:
type: string
format: date-time
SubscriptionNotFoundFault: {}
SubscriptionEventIdNotFoundFault: {}
String:
type: string
maxLength: 2147483647
TagList:
type: array
items:
allOf:
- $ref: '#/components/schemas/Tag'
- xml:
name: Tag
SubscriptionSeverityNotFoundFault: {}
SNSInvalidTopicFault: {}
EventCategoriesList:
type: array
items:
allOf:
- $ref: '#/components/schemas/String'
- xml:
name: EventCategory
InvalidSubscriptionStateFault: {}
SNSTopicArnNotFoundFault: {}
SourceIdsList:
type: array
items:
allOf:
- $ref: '#/components/schemas/String'
- xml:
name: SourceId
ModifyEventSubscriptionResult:
type: object
properties:
EventSubscription:
$ref: '#/components/schemas/EventSubscription'
SourceNotFoundFault: {}
Boolean:
type: boolean
EventSubscription:
type: object
properties:
CustomerAwsId:
allOf:
- $ref: '#/components/schemas/String'
- description: The Amazon Web Services account associated with the Amazon Redshift event notification subscription.
CustSubscriptionId:
allOf:
- $ref: '#/components/schemas/String'
- description: The name of the Amazon Redshift event notification subscription.
SnsTopicArn:
allOf:
- $ref: '#/components/schemas/String'
- description: The Amazon Resource Name (ARN) of the Amazon SNS topic used by the event notification subscription.
Status:
allOf:
- $ref: '#/components/schemas/String'
- description: 'The status of the Amazon Redshift event notification subscription.
Constraints:
Can be one of the following: active | no-permission | topic-not-exist
The status "no-permission" indicates that Amazon Redshift no longer has permission to post to the Amazon SNS topic. The status "topic-not-exist" indicates that the topic was deleted after the subscription was created.
The list of Amazon Redshift event categories specified in the event notification subscription.
Values: Configuration, Management, Monitoring, Security, Pending
' Severity: allOf: - $ref: '#/components/schemas/String' - description: 'The event severity specified in the Amazon Redshift event notification subscription.
Values: ERROR, INFO
' Enabled: allOf: - $ref: '#/components/schemas/Boolean' - description: A boolean value indicating whether the subscription is enabled;true indicates that the subscription is enabled.
Tags:
allOf:
- $ref: '#/components/schemas/TagList'
- description: The list of tags for the event subscription.
description: Describes event subscriptions.
ModifyEventSubscriptionMessage:
type: object
required:
- SubscriptionName
title: ModifyEventSubscriptionMessage
properties:
SubscriptionName:
allOf:
- $ref: '#/components/schemas/String'
- description: The name of the modified Amazon Redshift event notification subscription.
SnsTopicArn:
allOf:
- $ref: '#/components/schemas/String'
- description: The Amazon Resource Name (ARN) of the SNS topic to be used by the event notification subscription.
SourceType:
allOf:
- $ref: '#/components/schemas/String'
- description: 'The type of source that will be generating the events. For example, if you want to be notified of events generated by a cluster, you would set this parameter to cluster. If this value is not specified, events are returned for all Amazon Redshift objects in your Amazon Web Services account. You must specify a source type in order to specify source IDs.
Valid values: cluster, cluster-parameter-group, cluster-security-group, cluster-snapshot, and scheduled-action.
' SourceIds: allOf: - $ref: '#/components/schemas/SourceIdsList' - description: 'A list of one or more identifiers of Amazon Redshift source objects. All of the objects must be of the same type as was specified in the source type parameter. The event subscription will return only events generated by the specified objects. If not specified, then events are returned for all objects within the source type specified.
Example: my-cluster-1, my-cluster-2
Example: my-snapshot-20131010
' EventCategories: allOf: - $ref: '#/components/schemas/EventCategoriesList' - description: 'Specifies the Amazon Redshift event categories to be published by the event notification subscription.
Values: configuration, management, monitoring, security, pending
' Severity: allOf: - $ref: '#/components/schemas/String' - description: 'Specifies the Amazon Redshift event severity to be published by the event notification subscription.
Values: ERROR, INFO
' Enabled: allOf: - $ref: '#/components/schemas/BooleanOptional' - description: 'A Boolean value indicating if the subscription is enabled.true indicates the subscription is enabled '
description:
SNSNoAuthorizationFault: {}
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