querying-data-lake

SKILL.md

Query Data Lake

Execute SQL queries on Amazon Athena across default and federated catalogs (Glue, S3 Tables, Redshift) with workgroup selection, statement classification, and error recovery.

Overview

Executes and manages Athena SQL queries across default and federated catalogs. Selects a workgroup, resolves target assets (delegating fuzzy references to finding-data-lake-assets), classifies statements for safety, and reports cost and data scanned. Use the AWS MCP server for sandboxed execution and audit logging; the same AWS CLI commands work directly when the MCP server is not available.

Constraints for parameter acquisition:

You MUST accept a single optional argument: SQL text, a named-query name, a workgroup name, a catalog name, or profile TABLE_NAME

You MUST accept the argument as direct text or a pointer to a file containing SQL

You MUST ask the user for the target AWS region if not already set

You MUST confirm the output S3 location before executing any non-trivial query

You MUST respect the user's decision to abort at any step

Common Tasks

1. Verify Dependencies