QueryExecution
Information about a single instance of a query execution.
Contents
- EngineVersion
-
The engine version that executed the query.
Type: EngineVersion object
Required: No
- ExecutionParameters
-
A list of values for the parameters in a query. The values are applied sequentially to the parameters in the query in the order in which the parameters occur. The list of parameters is not returned in the response.
Type: Array of strings
Array Members: Minimum number of 1 item.
Length Constraints: Minimum length of 1. Maximum length of 1024.
Required: No
- Query
-
The SQL query statements which the query execution ran.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 262144.
Required: No
- QueryExecutionContext
-
The database in which the query execution occurred.
Type: QueryExecutionContext object
Required: No
- QueryExecutionId
-
The unique identifier for each query execution.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 128.
Pattern:
\S+
Required: No
- QueryResultsS3AccessGrantsConfiguration
-
Specifies whether Amazon S3 access grants are enabled for query results.
Type: QueryResultsS3AccessGrantsConfiguration object
Required: No
- ResultConfiguration
-
The location in Amazon S3 where query and calculation results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the location for the query results and the encryption configuration that are specified for the workgroup.
Type: ResultConfiguration object
Required: No
- ResultReuseConfiguration
-
Specifies the query result reuse behavior that was used for the query.
Type: ResultReuseConfiguration object
Required: No
- StatementType
-
The type of query statement that was run.
DDL
indicates DDL query statements.DML
indicates DML (Data Manipulation Language) query statements, such asCREATE TABLE AS SELECT
.UTILITY
indicates query statements other than DDL and DML, such asSHOW CREATE TABLE
, orDESCRIBE TABLE
.Type: String
Valid Values:
DDL | DML | UTILITY
Required: No
- Statistics
-
Query execution statistics, such as the amount of data scanned, the amount of time that the query took to process, and the type of statement that was run.
Type: QueryExecutionStatistics object
Required: No
- Status
-
The completion date, current state, submission time, and state change reason (if applicable) for the query execution.
Type: QueryExecutionStatus object
Required: No
- SubstatementType
-
The kind of query statement that was run.
Type: String
Required: No
- WorkGroup
-
The name of the workgroup in which the query ran.
Type: String
Pattern:
[a-zA-Z0-9._-]{1,128}
Required: No
See Also
For more information about using this API in one of the language-specific Amazon SDKs, see the following: