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_named_queries | Manage saved SQL queries in AWS Athena. This tool provides operations for creating, retrieving, updating, and deleting named queries in AWS Athena. Named queries are saved SQL statements that can be easily reused, shared with team members, and executed without having to rewrite complex queries. ## Requirements - The server must be run with the `--allow-write` flag for create-named-query, delete-named-query, and update-named-query operations - Appropriate AWS permissions for Athena named query operations ## Operations - **batch-get-named-query**: Get details for up to 50 named queries by their IDs - **create-named-query**: Save a new SQL query with a name and description - **delete-named-query**: Remove a saved query - **get-named-query**: Retrieve a single named query by ID - **list-named-queries**: List available named query IDs - **update-named-query**: Modify an existing named query ## Example ```python # Create a named query create_response = await manage_aws_athena_named_queries( operation='create-named-query', name='Daily Active Users', description='Query to calculate daily active users', database='analytics', query_string='SELECT date, COUNT(DISTINCT user_id) AS active_users FROM user_events GROUP BY date ORDER BY date DESC', work_group='primary', ) # Later, retrieve the named query query = await manage_aws_athena_named_queries( operation='get-named-query', named_query_id=create_response.named_query_id ) ``` |