querying-data-lake
querying data lake
What it does
- You MUST accept a single optional argument: SQL text, a named-query name, a workgroup name, a catalog name, or profile TABLENAME
- 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
- You MUST confirm credentials with aws sts get-caller-identity and inform the user about any missing tools
- You MUST select a workgroup before submitting any query (prevents output-location errors)
Requirements & configuration
- Table addressing depends on catalog type:
- | INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, MERGE | Destructive — warn the user and require explicit confirmation |
Configuration: SELECTSHOWDESCRIBEEXPLAININSERTUPDATEDELETEDROP
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
querying-data-lake FAQ
What does the querying-data-lake skill do?
>- Execute and manage Athena SQL queries across default and federated catalogs (Glue, S3 Tables, Redshift). Triggers on phrases like: query data, run SQL, athena query, analyze table, SQL query, workgroup status, profile table, query Redshift catalog, query S3 Tables. Do NOT use for finding specific data assets (use finding-data-lake-assets), full catalog audits (use exploring-data-catalog), importing data (use ingesting-into-data-lake). You MUST accept a single optional argument: SQL text, a named-query name, a workgroup name, a catalog name, or profile TABLENAME You MUST accept the argument as direct text or a pointer to a file containing SQL
What does querying-data-lake require?
Table addressing depends on catalog type: | INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, MERGE | Destructive — warn the user and require explicit confirmation | Configuration keys: SELECT, SHOW, DESCRIBE, EXPLAIN, INSERT, UPDATE, DELETE, DROP.
How do I install querying-data-lake?
Run: npx -y skills add https://github.com/aws/agent-toolkit-for-aws --skill querying-data-lake --agent claude-code — the source lives at github.com/aws/agent-toolkit-for-aws.
Maintain querying-data-lake?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[querying-data-lake on getagentictools](https://getagentictools.com/skills/aws-agent-toolkit-for-aws-querying-data-lake?ref=badge) npx agentictools info skills/aws-agent-toolkit-for-aws-querying-data-lake The second line is the CLI lookup for this page — handy in READMEs and docs.
