openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=CreateUsageLimit 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=CreateUsageLimit' paths: /#Action=CreateUsageLimit: 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: CreateUsageLimit operationId: GET_CreateUsageLimit description: Creates a usage limit for a specified Amazon Redshift feature on a cluster. The usage limit is identified by the returned usage limit identifier. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/UsageLimit' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' '482': description: LimitExceededFault content: text/xml: schema: $ref: '#/components/schemas/LimitExceededFault' '483': description: UsageLimitAlreadyExistsFault content: text/xml: schema: $ref: '#/components/schemas/UsageLimitAlreadyExistsFault' '484': description: InvalidUsageLimitFault content: text/xml: schema: $ref: '#/components/schemas/InvalidUsageLimitFault' '485': description: TagLimitExceededFault content: text/xml: schema: $ref: '#/components/schemas/TagLimitExceededFault' '486': description: UnsupportedOperationFault content: text/xml: schema: $ref: '#/components/schemas/UnsupportedOperationFault' parameters: - name: ClusterIdentifier in: query required: true description: The identifier of the cluster that you want to limit usage. schema: type: string maxLength: 2147483647 - name: FeatureType in: query required: true description: The Amazon Redshift feature that you want to limit. schema: type: string enum: - spectrum - concurrency-scaling - cross-region-datasharing - name: LimitType in: query required: true description: 'The type of limit. Depending on the feature type, this can be based on a time duration or data size. If FeatureType is spectrum, then LimitType must be data-scanned. If FeatureType is concurrency-scaling, then LimitType must be time. If FeatureType is cross-region-datasharing, then LimitType must be data-scanned. ' schema: type: string enum: - time - data-scanned - name: Amount in: query required: true description: 'The limit amount. If time-based, this amount is in minutes. If data-based, this amount is in terabytes (TB). The value must be a positive number. ' schema: type: integer - name: Period in: query required: false description: 'The time period that the amount applies to. A weekly period begins on Sunday. The default is monthly. ' schema: type: string enum: - daily - weekly - monthly - name: BreachAction in: query required: false description: The action that Amazon Redshift takes when the limit is reached. The default is log. For more information about this parameter, see UsageLimit. schema: type: string enum: - log - emit-metric - disable - name: Tags in: query required: false description: A list of tag instances. schema: type: array items: allOf: - $ref: '#/components/schemas/Tag' - xml: name: Tag - name: Action in: query required: true schema: type: string enum: - CreateUsageLimit - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Create Usage Limit x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=CreateUsageLimit' post: x-aws-operation-name: CreateUsageLimit operationId: POST_CreateUsageLimit description: Creates a usage limit for a specified Amazon Redshift feature on a cluster. The usage limit is identified by the returned usage limit identifier. responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/UsageLimit' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: InvalidClusterStateFault content: text/xml: schema: $ref: '#/components/schemas/InvalidClusterStateFault' '482': description: LimitExceededFault content: text/xml: schema: $ref: '#/components/schemas/LimitExceededFault' '483': description: UsageLimitAlreadyExistsFault content: text/xml: schema: $ref: '#/components/schemas/UsageLimitAlreadyExistsFault' '484': description: InvalidUsageLimitFault content: text/xml: schema: $ref: '#/components/schemas/InvalidUsageLimitFault' '485': description: TagLimitExceededFault content: text/xml: schema: $ref: '#/components/schemas/TagLimitExceededFault' '486': description: UnsupportedOperationFault content: text/xml: schema: $ref: '#/components/schemas/UnsupportedOperationFault' requestBody: content: text/xml: schema: $ref: '#/components/schemas/CreateUsageLimitMessage' parameters: - name: Action in: query required: true schema: type: string enum: - CreateUsageLimit - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Create Usage Limit x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=CreateUsageLimit' 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 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 UsageLimitLimitType: type: string enum: - time - data-scanned UsageLimitAlreadyExistsFault: {} 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. ' CreateUsageLimitMessage: type: object required: - ClusterIdentifier - FeatureType - LimitType - Amount title: CreateUsageLimitMessage properties: ClusterIdentifier: allOf: - $ref: '#/components/schemas/String' - description: The identifier of the cluster that you want to limit usage. FeatureType: allOf: - $ref: '#/components/schemas/UsageLimitFeatureType' - description: The Amazon Redshift feature that you want to limit. 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. If FeatureType is spectrum, then LimitType must be data-scanned. If FeatureType is concurrency-scaling, then LimitType must be time. If FeatureType is cross-region-datasharing, then LimitType must be data-scanned. ' 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). The value must be a positive number. ' 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. The default is log. For more information about this parameter, see UsageLimit. Tags: allOf: - $ref: '#/components/schemas/TagList' - description: A list of tag instances. InvalidUsageLimitFault: {} InvalidClusterStateFault: {} TagLimitExceededFault: {} UnsupportedOperationFault: {} Long: type: integer LimitExceededFault: {} 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