AWS Data Processing
Data processing and transformation services.
10K+pulls32 ToolsPackaged byDocker, with additional security features including SBOMs, provenance, signing, and multi-arch support
Tools
| Name | Description |
|---|---|
manage_aws_athena_query_executions | Execute and manage AWS Athena SQL queries. This tool provides comprehensive operations for AWS Athena query management, including starting new queries, monitoring execution status, retrieving results, and analyzing performance statistics. ## Requirements - The server must be run with the `--allow-write` flag if start-query-execution contains any write operation for example DDL commands, Insert, Update, Delete Commands or any flag updates - Appropriate AWS permissions for Athena query operations ## Operations - **batch-get-query-execution**: Get details for up to 50 query executions by their IDs - **get-query-execution**: Get complete information about a single query execution - **get-query-results**: Retrieve the results of a completed query - **get-query-runtime-statistics**: Get performance statistics for a query execution - **list-query-executions**: List available query execution IDs (up to 50) - **start-query-execution**: Execute a new SQL query - **stop-query-execution**: Cancel a running query ## Example ```python # Start a new query response = await manage_aws_athena_queries( operation='start-query-execution', query_string='SELECT * FROM my_database.my_table LIMIT 10', query_execution_context={'Database': 'my_database', 'Catalog': 'my_catalog'}, work_group='primary', ) # Get the query results results = await manage_aws_athena_queries( operation='get-query-results', query_execution_id=response.query_execution_id ) ``` |