athena_get_query_execution: Returns information about a single execution of a query if you have access to the workgroup in which the query ran

Description

Returns information about a single execution of a query if you have access to the workgroup in which the query ran. Each time a query executes, information about the query execution is saved with a unique ID.

Usage

athena_get_query_execution(QueryExecutionId)

Arguments

QueryExecutionId

[required] The unique ID of the query execution.

Value

A list with the following syntax:

list(
  QueryExecution = list(
    QueryExecutionId = "string",
    Query = "string",
    StatementType = "DDL"|"DML"|"UTILITY",
    ResultConfiguration = list(
      OutputLocation = "string",
      EncryptionConfiguration = list(
        EncryptionOption = "SSE_S3"|"SSE_KMS"|"CSE_KMS",
        KmsKey = "string"
      )
    ),
    QueryExecutionContext = list(
      Database = "string",
      Catalog = "string"
    ),
    Status = list(
      State = "QUEUED"|"RUNNING"|"SUCCEEDED"|"FAILED"|"CANCELLED",
      StateChangeReason = "string",
      SubmissionDateTime = as.POSIXct(
        "2015-01-01"
      ),
      CompletionDateTime = as.POSIXct(
        "2015-01-01"
      )
    ),
    Statistics = list(
      EngineExecutionTimeInMillis = 123,
      DataScannedInBytes = 123,
      DataManifestLocation = "string",
      TotalExecutionTimeInMillis = 123,
      QueryQueueTimeInMillis = 123,
      QueryPlanningTimeInMillis = 123,
      ServiceProcessingTimeInMillis = 123
    ),
    WorkGroup = "string"
  )
)

Request syntax

svc$get_query_execution(
  QueryExecutionId = "string"
)