awswrangler.athena.get_query_executions

awswrangler.athena.get_query_executions(query_execution_ids: list[str], return_unprocessed: bool = False, boto3_session: Session | None = None) → tuple[pandas.core.frame.DataFrame, pandas.core.frame.DataFrame] | DataFrame

From specified query execution IDs, return a DataFrame of query execution details.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.batch_get_query_execution

Parameters:

  • query_execution_ids (list[str]) – Athena query execution IDs.

  • return_unprocessed (bool) – True to also return query executions id that are unable to be processed. False to only return DataFrame of query execution details. Default is False

  • boto3_session (Session | None) – The default boto3 session will be used if boto3_session is None.

Return type:

tuple[DataFrame, DataFrame] | DataFrame

Returns:

DataFrame containing either information about query execution details. Optionally, another DataFrame containing unprocessed query execution IDs.

Examples

>>> import awswrangler as wr
>>> query_executions_df, unprocessed_query_executions_df = wr.athena.get_query_executions(
>>>     query_execution_ids=['query-execution-id','query-execution-id1']
>>> )