openapi: 3.0.0 info: version: '2019-12-20' x-release: v4 title: 'Redshift Data API Service #Action=AcceptReservedNodeExchange #Action=AcceptReservedNodeExchange #Action=GetClusterCredentialsWithIAM 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=GetClusterCredentialsWithIAM' paths: /#Action=GetClusterCredentialsWithIAM: 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: GetClusterCredentialsWithIAM operationId: GET_GetClusterCredentialsWithIAM description:Returns a database user name and temporary password with temporary authorization to log in to an Amazon Redshift database. The database user is mapped 1:1 to the source Identity and Access Management (IAM) identity. For more information about IAM identities, see IAM Identities (users, user groups, and roles) in the Amazon Web Services Identity and Access Management User Guide.
The Identity and Access Management (IAM) identity that runs this operation must have an IAM policy attached that allows access to all necessary actions and resources. For more information about permissions, see Using identity-based policies (IAM policies) in the Amazon Redshift Cluster Management Guide.
responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterExtendedCredentials' '480': description: ClusterNotFoundFault content: text/xml: schema: $ref: '#/components/schemas/ClusterNotFoundFault' '481': description: UnsupportedOperationFault content: text/xml: schema: $ref: '#/components/schemas/UnsupportedOperationFault' parameters: - name: DbName in: query required: false description: The name of the database for which you are requesting credentials. If the database name is specified, the IAM policy must allow access to the resourcedbname for the specified database name. If the database name is not specified, access to all databases is allowed.
schema:
type: string
maxLength: 2147483647
- name: ClusterIdentifier
in: query
required: true
description: 'The unique identifier of the cluster that contains the database for which you are requesting credentials. '
schema:
type: string
maxLength: 2147483647
- name: DurationSeconds
in: query
required: false
description: 'The number of seconds until the returned temporary password expires.
Range: 900-3600. Default: 900.
' schema: type: integer - name: Action in: query required: true schema: type: string enum: - GetClusterCredentialsWithIAM - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - G E T_ Get Cluster Credentials with I a M x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=GetClusterCredentialsWithIAM' post: x-aws-operation-name: GetClusterCredentialsWithIAM operationId: POST_GetClusterCredentialsWithIAM description:Returns a database user name and temporary password with temporary authorization to log in to an Amazon Redshift database. The database user is mapped 1:1 to the source Identity and Access Management (IAM) identity. For more information about IAM identities, see IAM Identities (users, user groups, and roles) in the Amazon Web Services Identity and Access Management User Guide.
The Identity and Access Management (IAM) identity that runs this operation must have an IAM policy attached that allows access to all necessary actions and resources. For more information about permissions, see Using identity-based policies (IAM policies) in the Amazon Redshift Cluster Management Guide.
responses: '200': description: Success content: text/xml: schema: $ref: '#/components/schemas/ClusterExtendedCredentials' '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/GetClusterCredentialsWithIAMMessage' parameters: - name: Action in: query required: true schema: type: string enum: - GetClusterCredentialsWithIAM - name: Version in: query required: true schema: type: string enum: - '2012-12-01' summary: Amazon Redshift - P O S T_ Get Cluster Credentials with I a M x-microcks-operation: delay: 0 dispatcher: FALLBACK tags: - '#Action=GetClusterCredentialsWithIAM' components: parameters: X-Amz-Credential: name: X-Amz-Credential in: header schema: type: string required: false X-Amz-SignedHeaders: name: X-Amz-SignedHeaders 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-Content-Sha256: name: X-Amz-Content-Sha256 in: header schema: type: string required: false X-Amz-Date: name: X-Amz-Date in: header schema: type: string required: false X-Amz-Signature: name: X-Amz-Signature in: header schema: type: string required: false X-Amz-Algorithm: name: X-Amz-Algorithm in: header schema: type: string required: false schemas: IntegerOptional: type: integer ClusterExtendedCredentials: type: object properties: DbUser: allOf: - $ref: '#/components/schemas/String' - description: 'A database user name that you provide when you connect to a database. The database user is mapped 1:1 to the source IAM identity. ' DbPassword: allOf: - $ref: '#/components/schemas/SensitiveString' - description: A temporary password that you provide when you connect to a database. Expiration: allOf: - $ref: '#/components/schemas/TStamp' - description: The time (UTC) when the temporary password expires. After this timestamp, a log in with the temporary password fails. NextRefreshTime: allOf: - $ref: '#/components/schemas/TStamp' - description: Reserved for future use. GetClusterCredentialsWithIAMMessage: type: object required: - ClusterIdentifier title: GetClusterCredentialsWithIAMMessage properties: DbName: allOf: - $ref: '#/components/schemas/String' - description: The name of the database for which you are requesting credentials. If the database name is specified, the IAM policy must allow access to the resourcedbname for the specified database name. If the database name is not specified, access to all databases is allowed.
ClusterIdentifier:
allOf:
- $ref: '#/components/schemas/String'
- description: 'The unique identifier of the cluster that contains the database for which you are requesting credentials. '
DurationSeconds:
allOf:
- $ref: '#/components/schemas/IntegerOptional'
- description: 'The number of seconds until the returned temporary password expires.
Range: 900-3600. Default: 900.
' TStamp: type: string format: date-time UnsupportedOperationFault: {} SensitiveString: type: string format: password ClusterNotFoundFault: {} String: type: string maxLength: 2147483647 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