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. IfFeatureType 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:
log - To log an event in a system table. The default is log.
emit-metric - To emit CloudWatch metrics.
disable - To disable the feature until the next usage period begins.
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