openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=DescribeEndpointAccess 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=DescribeEndpointAccess' paths: /#Action=DescribeEndpointAccess: 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: DescribeEndpointAccess operationId: GET_DescribeEndpointAccess description: Describes a Redshift-managed VPC endpoint. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/EndpointAccessList' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' '482': description: EndpointNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/EndpointNotFoundFault' parameters: - name: ClusterIdentifier in: query required: false description: The cluster identifier associated with the described endpoint. schema: type: string maxLength: 2147483647 - name: ResourceOwner in: query required: false description: The Amazon Web Services account ID of the owner of the cluster. schema: type: string maxLength: 2147483647 - name: EndpointName in: query required: false description: The name of the endpoint to be described. schema: type: string maxLength: 2147483647 - name: VpcId in: query required: false description: The virtual private cloud (VPC) identifier with access to the cluster. schema: type: string maxLength: 2147483647 - name: MaxRecords in: query required: false description: The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a Marker is included in the response so that the remaining results can be retrieved. schema: type: integer - name: Marker in: query required: false description: An optional pagination token provided by a previous DescribeEndpointAccess request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter. schema: type: string maxLength: 2147483647 - name: Action in: query required: true schema: type: string enum: - DescribeEndpointAccess - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Describe Endpoint Access x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeEndpointAccess' post: x-aws-operation-name: DescribeEndpointAccess operationId: POST_DescribeEndpointAccess description: Describes a Redshift-managed VPC endpoint. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/EndpointAccessList' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' '482': description: EndpointNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/EndpointNotFoundFault' requestBody: content: text/xml: schema: $ref: '#/components/schemas/DescribeEndpointAccessMessage' 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: - DescribeEndpointAccess - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Describe Endpoint Access x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeEndpointAccess' 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: NetworkInterface: type: object properties: NetworkInterfaceId: allOf: - $ref: '#/components/schemas/String' - description: 'The network interface identifier. ' SubnetId: allOf: - $ref: '#/components/schemas/String' - description: 'The subnet identifier. ' PrivateIpAddress: allOf: - $ref: '#/components/schemas/String' - description: 'The IPv4 address of the network interface within the subnet. ' AvailabilityZone: allOf: - $ref: '#/components/schemas/String' - description: 'The Availability Zone. ' description: 'Describes a network interface. ' TStamp: type: string format: date-time Integer: type: integer String: type: string maxLength: 2147483647 EndpointAccess: type: object properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The cluster identifier of the cluster associated with the endpoint. ResourceOwner: allOf: - $ref: '#/components/schemas/String' - description: The Amazon Web Services account ID of the owner of the cluster. SubnetGroupName: allOf: - $ref: '#/components/schemas/String' - description: The subnet group name where Amazon Redshift chooses to deploy the endpoint. EndpointStatus: allOf: - $ref: '#/components/schemas/String' - description: The status of the endpoint. EndpointName: allOf: - $ref: '#/components/schemas/String' - description: The name of the endpoint. EndpointCreateTime: allOf: - $ref: '#/components/schemas/TStamp' - description: The time (UTC) that the endpoint was created. Port: allOf: - $ref: '#/components/schemas/Integer' - description: The port number on which the cluster accepts incoming connections. Address: allOf: - $ref: '#/components/schemas/String' - description: The DNS address of the endpoint. VpcSecurityGroups: allOf: - $ref: '#/components/schemas/VpcSecurityGroupMembershipList' - description: The security groups associated with the endpoint. VpcEndpoint: $ref: '#/components/schemas/VpcEndpoint' description: Describes a Redshift-managed VPC endpoint. EndpointNotFoundFault: {} NetworkInterfaceList: type: array items: allOf: - $ref: '#/components/schemas/NetworkInterface' - xml: name: NetworkInterface InvalidClusterStateFault: {} VpcEndpoint: type: object properties: VpcEndpointId: allOf: - $ref: '#/components/schemas/String' - description: The connection endpoint ID for connecting an Amazon Redshift cluster through the proxy. VpcId: allOf: - $ref: '#/components/schemas/String' - description: 'The VPC identifier that the endpoint is associated. ' NetworkInterfaces: allOf: - $ref: '#/components/schemas/NetworkInterfaceList' - description: 'One or more network interfaces of the endpoint. Also known as an interface endpoint. ' description: The connection endpoint for connecting to an Amazon Redshift cluster through the proxy. DescribeEndpointAccessMessage: type: object title: DescribeEndpointAccessMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The cluster identifier associated with the described endpoint. ResourceOwner: allOf: - $ref: '#/components/schemas/String' - description: The Amazon Web Services account ID of the owner of the cluster. EndpointName: allOf: - $ref: '#/components/schemas/String' - description: The name of the endpoint to be described. VpcId: allOf: - $ref: '#/components/schemas/String' - description: The virtual private cloud (VPC) identifier with access to the cluster. MaxRecords: allOf: - $ref: '#/components/schemas/IntegerOptional' - description: The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a Marker is included in the response so that the remaining results can be retrieved. Marker: allOf: - $ref: '#/components/schemas/String' - description: An optional pagination token provided by a previous DescribeEndpointAccess request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter. EndpointAccessList: type: object properties: EndpointAccessList: allOf: - $ref: '#/components/schemas/EndpointAccesses' - description: The list of endpoints with access to the cluster. Marker: allOf: - $ref: '#/components/schemas/String' - description: An optional pagination token provided by a previous DescribeEndpointAccess request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter. VpcSecurityGroupMembership: type: object properties: VpcSecurityGroupId: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the VPC security group. Status: allOf: - $ref: '#/components/schemas/String' - description: The status of the VPC security group. description: Describes the members of a VPC security group. VpcSecurityGroupMembershipList: type: array items: allOf: - $ref: '#/components/schemas/VpcSecurityGroupMembership' - xml: name: VpcSecurityGroup IntegerOptional: type: integer ClusterNotFoundFault: {} EndpointAccesses: type: array items: $ref: '#/components/schemas/EndpointAccess' 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