@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_METRICENDPOINT_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, withTimeOffsetpublic 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 AWSRedshiftDataAPIbatchExecuteStatementRequest - 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 AWSRedshiftDataAPIcancelStatementRequest - 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 AWSRedshiftDataAPIdescribeStatementRequest - 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 AWSRedshiftDataAPIdescribeTableRequest - 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 AWSRedshiftDataAPIexecuteStatementRequest - 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 AWSRedshiftDataAPIgetStatementResultRequest - 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 AWSRedshiftDataAPIlistDatabasesRequest - 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 AWSRedshiftDataAPIlistSchemasRequest - 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 AWSRedshiftDataAPIlistStatementsRequest - 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 AWSRedshiftDataAPIlistTablesRequest - 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 AWSRedshiftDataAPIrequest - The originally executed requestpublic void shutdown()
AmazonWebServiceClientshutdown in interface AWSRedshiftDataAPIshutdown in class AmazonWebServiceClient