Skills
.Work. You
Rest

querying-data-lake

Community

Run Athena SQL safely with smart catalogs.

Data & Analytics#athena#sql querying#data lake#workgroup selection#catalog resolution#statement safety#cost and scan reporting
Authormreferre
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps you execute Athena SQL queries across your data lake while safely handling workgroups, catalogs, and table discovery so you don’t waste tokens, scan unnecessary data, or hit output-location errors.

Core Features & Use Cases

  • Athena query execution with guardrails: Classifies statements (safe vs potentially destructive), warns on risky scopes (Redshift-federated, cross-catalog joins), and confirms output S3 location before running non-trivial queries.
  • Workgroup-aware querying: Selects a workgroup first, surfaces its output location, and retries only in controlled cases (with user confirmation) when output-location configuration is missing.
  • Target asset resolution & profiling: Resolves fuzzy table references (delegating to finding-data-lake-assets), profiles unfamiliar tables with sample rows, and then builds the final SQL with correct catalog qualification rules.

Quick Start

Ask it to query your data lake with: "Query the orders table with SQL to return the top 10 orders by revenue for the last 30 days."

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: querying-data-lake
Download link: https://github.com/mreferre/aws-agent-toolkit-skills/archive/main.zip#querying-data-lake

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.