@ThreadSafe @Generated(value="com.amazonaws:aws-java-sdk-code-generator") public class AWSRedshiftDataAPIClient extends AmazonWebServiceClient implements AWSRedshiftDataAPI
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, see Using the Amazon Redshift Data API in the Amazon Redshift Cluster Management Guide.
LOGGING_AWS_REQUEST_METRIC
ENDPOINT_PREFIX
Modifier and Type | Method and Description |
---|---|
BatchExecuteStatementResult |
batchExecuteStatement(BatchExecuteStatementRequest request)
Runs one or more SQL statements, which can be data manipulation language (DML) or data definition language (DDL).
|
static AWSRedshiftDataAPIClientBuilder |
builder() |
CancelStatementResult |
cancelStatement(CancelStatementRequest request)
Cancels a running query.
|
DescribeStatementResult |
describeStatement(DescribeStatementRequest request)
Describes the details about a specific instance when a query was run by the Amazon Redshift Data API.
|
DescribeTableResult |
describeTable(DescribeTableRequest request)
Describes the detailed information about a table from metadata in the cluster.
|
ExecuteStatementResult |
executeStatement(ExecuteStatementRequest request)
Runs an SQL statement, which can be data manipulation language (DML) or data definition language (DDL).
|
ResponseMetadata |
getCachedResponseMetadata(AmazonWebServiceRequest request)
Returns additional metadata for a previously executed successful, request, typically used for debugging issues
where a service isn't acting as expected.
|
GetStatementResultResult |
getStatementResult(GetStatementResultRequest request)
Fetches the temporarily cached result of an SQL statement.
|
ListDatabasesResult |
listDatabases(ListDatabasesRequest request)
List the databases in a cluster.
|
ListSchemasResult |
listSchemas(ListSchemasRequest request)
Lists the schemas in a database.
|
ListStatementsResult |
listStatements(ListStatementsRequest request)
List of SQL statements.
|
ListTablesResult |
listTables(ListTablesRequest request)
List the tables in a database.
|
void |
shutdown()
Shuts down this client object, releasing any resources that might be held
open.
|
addRequestHandler, addRequestHandler, configureRegion, getClientConfiguration, getEndpointPrefix, getMonitoringListeners, getRequestMetricsCollector, getServiceName, getSignerByURI, getSignerOverride, getSignerRegionOverride, getTimeOffset, makeImmutable, removeRequestHandler, removeRequestHandler, setEndpoint, setEndpoint, setRegion, setServiceNameIntern, setSignerRegionOverride, setTimeOffset, withEndpoint, withRegion, withRegion, withTimeOffset
public static AWSRedshiftDataAPIClientBuilder builder()
public BatchExecuteStatementResult batchExecuteStatement(BatchExecuteStatementRequest request)
Runs one or more SQL statements, which can be data manipulation language (DML) or data definition language (DDL). Depending on the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
batchExecuteStatement
in interface AWSRedshiftDataAPI
batchExecuteStatementRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.ActiveStatementsExceededException
- The number of active statements exceeds the limit.BatchExecuteStatementException
- An SQL statement encountered an environmental error while running.public CancelStatementResult cancelStatement(CancelStatementRequest request)
Cancels a running query. To be canceled, a query must be running.
cancelStatement
in interface AWSRedshiftDataAPI
cancelStatementRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.ResourceNotFoundException
- The Amazon Redshift Data API operation failed due to a missing resource.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public DescribeStatementResult describeStatement(DescribeStatementRequest request)
Describes the details about a specific instance when a query was run by the Amazon Redshift Data API. The information includes when the query started, when it finished, the query status, the number of rows returned, and the SQL statement.
describeStatement
in interface AWSRedshiftDataAPI
describeStatementRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.ResourceNotFoundException
- The Amazon Redshift Data API operation failed due to a missing resource.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public DescribeTableResult describeTable(DescribeTableRequest request)
Describes the detailed information about a table from metadata in the cluster. The information includes its columns. A token is returned to page through the column list. Depending on the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
describeTable
in interface AWSRedshiftDataAPI
describeTableRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ExecuteStatementResult executeStatement(ExecuteStatementRequest request)
Runs an SQL statement, which can be data manipulation language (DML) or data definition language (DDL). This statement must be a single SQL statement. Depending on the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
executeStatement
in interface AWSRedshiftDataAPI
executeStatementRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.ExecuteStatementException
- The SQL statement encountered an environmental error while running.ActiveStatementsExceededException
- The number of active statements exceeds the limit.public GetStatementResultResult getStatementResult(GetStatementResultRequest request)
Fetches the temporarily cached result of an SQL statement. A token is returned to page through the statement results.
getStatementResult
in interface AWSRedshiftDataAPI
getStatementResultRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.ResourceNotFoundException
- The Amazon Redshift Data API operation failed due to a missing resource.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ListDatabasesResult listDatabases(ListDatabasesRequest request)
List the databases in a cluster. A token is returned to page through the database list. Depending on the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
listDatabases
in interface AWSRedshiftDataAPI
listDatabasesRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ListSchemasResult listSchemas(ListSchemasRequest request)
Lists the schemas in a database. A token is returned to page through the schema list. Depending on the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
listSchemas
in interface AWSRedshiftDataAPI
listSchemasRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ListStatementsResult listStatements(ListStatementsRequest request)
List of SQL statements. By default, only finished statements are shown. A token is returned to page through the statement list.
listStatements
in interface AWSRedshiftDataAPI
listStatementsRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ListTablesResult listTables(ListTablesRequest request)
List the tables in a database. If neither SchemaPattern
nor TablePattern
are specified,
then all tables in the database are returned. A token is returned to page through the table list. Depending on
the authorization method, use one of the following combinations of request parameters:
Secrets Manager - specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret.
Temporary credentials - specify the cluster identifier, the database name, and the database user name. Permission
to call the redshift:GetClusterCredentials
operation is required to use this method.
listTables
in interface AWSRedshiftDataAPI
listTablesRequest
- ValidationException
- The Amazon Redshift Data API operation failed due to invalid input.InternalServerException
- The Amazon Redshift Data API operation failed due to invalid input.public ResponseMetadata getCachedResponseMetadata(AmazonWebServiceRequest request)
Response metadata is only cached for a limited period of time, so if you need to access this extra diagnostic information for an executed request, you should use this method to retrieve it as soon as possible after executing the request.
getCachedResponseMetadata
in interface AWSRedshiftDataAPI
request
- The originally executed requestpublic void shutdown()
AmazonWebServiceClient
shutdown
in interface AWSRedshiftDataAPI
shutdown
in class AmazonWebServiceClient