openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=DescribeClusterSubnetGroups 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=DescribeClusterSubnetGroups' paths: /#Action=DescribeClusterSubnetGroups: 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: DescribeClusterSubnetGroups operationId: GET_DescribeClusterSubnetGroups description:

Returns one or more cluster subnet group objects, which contain metadata about your cluster subnet groups. By default, this operation returns information about all cluster subnet groups that are defined in your Amazon Web Services account.

If you specify both tag keys and tag values in the same request, Amazon Redshift returns all subnet groups that match any combination of the specified keys and values. For example, if you have owner and environment for tag keys, and admin and test for tag values, all subnet groups that have any combination of those values are returned.

If both tag keys and values are omitted from the request, subnet groups are returned regardless of whether they have tag keys or values associated with them.

responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterSubnetGroupMessage' '480': description: ClusterSubnetGroupNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterSubnetGroupNotFoundFault' '481': description: InvalidTagFault content: text/xml: schema: $ref: '#/components/schemas/InvalidTagFault' parameters: - name: ClusterSubnetGroupName in: query required: false description: The name of the cluster subnet group for which information is requested. 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 a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

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 to return a set of response records. When the results of a DescribeClusterSubnetGroups request exceed the value specified in MaxRecords, Amazon Web Services 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. ' schema: type: string maxLength: 2147483647 - name: TagKeys in: query required: false description: A tag key or keys for which you want to return all matching cluster subnet groups that are associated with the specified key or keys. For example, suppose that you have subnet groups that are tagged with keys called owner and environment. If you specify both of these tag keys in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag keys associated with them. schema: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagKey - name: TagValues in: query required: false description: A tag value or values for which you want to return all matching cluster subnet groups that are associated with the specified tag value or values. For example, suppose that you have subnet groups that are tagged with values called admin and test. If you specify both of these tag values in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag values associated with them. schema: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagValue - name: Action in: query required: true schema: type: string enum: - DescribeClusterSubnetGroups - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Describe Cluster Subnet Groups x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeClusterSubnetGroups' post: x-aws-operation-name: DescribeClusterSubnetGroups operationId: POST_DescribeClusterSubnetGroups description:

Returns one or more cluster subnet group objects, which contain metadata about your cluster subnet groups. By default, this operation returns information about all cluster subnet groups that are defined in your Amazon Web Services account.

If you specify both tag keys and tag values in the same request, Amazon Redshift returns all subnet groups that match any combination of the specified keys and values. For example, if you have owner and environment for tag keys, and admin and test for tag values, all subnet groups that have any combination of those values are returned.

If both tag keys and values are omitted from the request, subnet groups are returned regardless of whether they have tag keys or values associated with them.

responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterSubnetGroupMessage' '480': description: ClusterSubnetGroupNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterSubnetGroupNotFoundFault' '481': description: InvalidTagFault content: text/xml: schema: $ref: '#/components/schemas/InvalidTagFault' requestBody: content: text/xml: schema: $ref: '#/components/schemas/DescribeClusterSubnetGroupsMessage' 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: - DescribeClusterSubnetGroups - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Describe Cluster Subnet Groups x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeClusterSubnetGroups' 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: 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. TagValueList: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagValue InvalidTagFault: {} AvailabilityZone: type: object properties: Name: allOf: - $ref: '#/components/schemas/String' - description: The name of the availability zone. SupportedPlatforms: allOf: - $ref: '#/components/schemas/SupportedPlatformsList' - description:

description: Describes an availability zone. String: type: string maxLength: 2147483647 TagList: type: array items: allOf: - $ref: '#/components/schemas/Tag' - xml: name: Tag Subnet: type: object properties: SubnetIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the subnet. SubnetAvailabilityZone: allOf: - $ref: '#/components/schemas/AvailabilityZone' - description:

SubnetStatus: allOf: - $ref: '#/components/schemas/String' - description: The status of the subnet. description: Describes a subnet. SubnetList: type: array items: allOf: - $ref: '#/components/schemas/Subnet' - xml: name: Subnet DescribeClusterSubnetGroupsMessage: type: object title: DescribeClusterSubnetGroupsMessage properties: ClusterSubnetGroupName: allOf: - $ref: '#/components/schemas/String' - description: The name of the cluster subnet group for which information is requested. 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 a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

' Marker: allOf: - $ref: '#/components/schemas/String' - description: 'An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeClusterSubnetGroups request exceed the value specified in MaxRecords, Amazon Web Services 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. ' TagKeys: allOf: - $ref: '#/components/schemas/TagKeyList' - description: A tag key or keys for which you want to return all matching cluster subnet groups that are associated with the specified key or keys. For example, suppose that you have subnet groups that are tagged with keys called owner and environment. If you specify both of these tag keys in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag keys associated with them. TagValues: allOf: - $ref: '#/components/schemas/TagValueList' - description: A tag value or values for which you want to return all matching cluster subnet groups that are associated with the specified tag value or values. For example, suppose that you have subnet groups that are tagged with values called admin and test. If you specify both of these tag values in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag values associated with them. description:

ClusterSubnetGroups: type: array items: allOf: - $ref: '#/components/schemas/ClusterSubnetGroup' - xml: name: ClusterSubnetGroup ClusterSubnetGroupNotFoundFault: {} ClusterSubnetGroup: type: object properties: ClusterSubnetGroupName: allOf: - $ref: '#/components/schemas/String' - description: The name of the cluster subnet group. Description: allOf: - $ref: '#/components/schemas/String' - description: The description of the cluster subnet group. VpcId: allOf: - $ref: '#/components/schemas/String' - description: The VPC ID of the cluster subnet group. SubnetGroupStatus: allOf: - $ref: '#/components/schemas/String' - description: 'The status of the cluster subnet group. Possible values are Complete, Incomplete and Invalid. ' Subnets: allOf: - $ref: '#/components/schemas/SubnetList' - description: 'A list of the VPC Subnet elements. ' Tags: allOf: - $ref: '#/components/schemas/TagList' - description: The list of tags for the cluster subnet group. description: Describes a subnet group. SupportedPlatformsList: type: array items: allOf: - $ref: '#/components/schemas/SupportedPlatform' - xml: name: SupportedPlatform IntegerOptional: type: integer ClusterSubnetGroupMessage: type: object properties: Marker: allOf: - $ref: '#/components/schemas/String' - description: 'A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request. ' ClusterSubnetGroups: allOf: - $ref: '#/components/schemas/ClusterSubnetGroups' - description: 'A list of ClusterSubnetGroup instances. ' description: 'Contains the output from the DescribeClusterSubnetGroups action. ' TagKeyList: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagKey SupportedPlatform: type: object properties: Name: allOf: - $ref: '#/components/schemas/String' - description:

description: A list of supported platforms for orderable clusters. 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