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

Shows usage limits on a cluster. Results are filtered based on the combination of input usage limit identifier, cluster identifier, and feature type parameters:

responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/UsageLimitList' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: UnsupportedOperationFault content: text/xml: schema: $ref: '#/components/schemas/UnsupportedOperationFault' parameters: - name: UsageLimitId in: query required: false description: The identifier of the usage limit to describe. schema: type: string maxLength: 2147483647 - name: ClusterIdentifier in: query required: false description: The identifier of the cluster for which you want to describe usage limits. schema: type: string maxLength: 2147483647 - name: FeatureType in: query required: false description: The feature type for which you want to describe usage limits. schema: type: string enum: - spectrum - concurrency-scaling - cross-region-datasharing - 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 DescribeUsageLimits 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 usage limit objects that are associated with the specified key or keys. For example, suppose that you have parameter 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 usage limit objects 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 usage limit objects that are associated with the specified tag value or values. For example, suppose that you have parameter 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 usage limit objects 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: - DescribeUsageLimits - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Describe Usage Limits x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeUsageLimits' post: x-aws-operation-name: DescribeUsageLimits operationId: POST_DescribeUsageLimits description:

Shows usage limits on a cluster. Results are filtered based on the combination of input usage limit identifier, cluster identifier, and feature type parameters:

responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/UsageLimitList' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: UnsupportedOperationFault content: text/xml: schema: $ref: '#/components/schemas/UnsupportedOperationFault' requestBody: content: text/xml: schema: $ref: '#/components/schemas/DescribeUsageLimitsMessage' 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: - DescribeUsageLimits - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Describe Usage Limits x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=DescribeUsageLimits' 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: UsageLimitFeatureType: type: string enum: - spectrum - concurrency-scaling - cross-region-datasharing UsageLimitBreachAction: type: string enum: - log - emit-metric - disable UsageLimitList: type: object properties: UsageLimits: allOf: - $ref: '#/components/schemas/UsageLimits' - description: 'Contains the output from the DescribeUsageLimits action. ' 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. ' 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. UsageLimitPeriod: type: string enum: - daily - weekly - monthly TagValueList: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagValue UsageLimitLimitType: type: string enum: - time - data-scanned String: type: string maxLength: 2147483647 TagList: type: array items: allOf: - $ref: '#/components/schemas/Tag' - xml: name: Tag UsageLimit: type: object properties: UsageLimitId: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the usage limit. ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the cluster with a usage limit. FeatureType: allOf: - $ref: '#/components/schemas/UsageLimitFeatureType' - description: The Amazon Redshift feature to which the limit applies. LimitType: allOf: - $ref: '#/components/schemas/UsageLimitLimitType' - description: The type of limit. Depending on the feature type, this can be based on a time duration or data size. Amount: allOf: - $ref: '#/components/schemas/Long' - description: The limit amount. If time-based, this amount is in minutes. If data-based, this amount is in terabytes (TB). Period: allOf: - $ref: '#/components/schemas/UsageLimitPeriod' - description: 'The time period that the amount applies to. A weekly period begins on Sunday. The default is monthly. ' BreachAction: allOf: - $ref: '#/components/schemas/UsageLimitBreachAction' - description: '

The action that Amazon Redshift takes when the limit is reached. Possible values are:

' Tags: allOf: - $ref: '#/components/schemas/TagList' - description: A list of tag instances. description: 'Describes a usage limit object for a cluster. ' UsageLimits: type: array items: $ref: '#/components/schemas/UsageLimit' IntegerOptional: type: integer DescribeUsageLimitsMessage: type: object title: DescribeUsageLimitsMessage properties: UsageLimitId: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the usage limit to describe. ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the cluster for which you want to describe usage limits. FeatureType: allOf: - $ref: '#/components/schemas/UsageLimitFeatureType' - description: The feature type for which you want to describe usage limits. 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 DescribeUsageLimits 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 usage limit objects that are associated with the specified key or keys. For example, suppose that you have parameter 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 usage limit objects 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 usage limit objects that are associated with the specified tag value or values. For example, suppose that you have parameter 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 usage limit objects that have either or both of these tag values associated with them. UnsupportedOperationFault: {} Long: type: integer TagKeyList: type: array items: allOf: - $ref: '#/components/schemas/String' - xml: name: TagKey ClusterNotFoundFault: {} 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