skills.rest
david-2814
david-2814COMMUNITY
Explore all skills by this author →
GitHub

athena

Run SQL queries against S3 data using Amazon Athena.

3|Updated Mar 16, 2026
Search Tags:#aws#sql#s3#athena#query-history#workgroups#named-queries
One-click install
npx skills add https://github.com/david-2814/claw-aws --skill athena
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: athena
Source: https://github.com/david-2814/claw-aws/tree/main/skills/athena
Command: npx skills add https://github.com/david-2814/claw-aws --skill athena

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyzing large datasets stored in S3 can be cumbersome without a scalable, serverless SQL engine. This skill enables executing SQL queries against S3 data using Amazon Athena, managing workgroups, saved queries, and query history to streamline analytics workflows.

Core Features & Use Cases

  • Interactive SQL querying against data in S3 using Athena.
  • Manage workgroups, stored queries, and query history for repeatable analytics.
  • Use case: quickly validate data patterns or generate insights across multiple datasets with minimal setup.

Quick Start

Install and configure AWS CLI, then run an Athena query against a sample dataset to verify connectivity and performance.

Frequently Asked Questions about athena

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL queries against S3 data using Amazon Athena?▼

To run SQL queries against S3 data using Amazon Athena, you need AWS CLI v2 with configured IAM permissions for Athena, S3, and Glue, plus a Glue Data Catalog to manage table schemas for serverless querying.

Can I manage Athena workgroups and query history for multi-user environments?▼

Yes, you can manage Athena workgroups and query history for multi-user environments. Workgroups enable governance and control over query execution, while query history tracks analytics workflows for repeatable insights.

What AWS IAM permissions do I need to query S3 with Athena?▼

Querying S3 with Athena requires IAM permissions for the Athena service, S3 storage, and Glue Data Catalog. AWS CLI v2 must be installed and configured to authenticate requests for scalable, serverless SQL analytics.

How do I save and reuse SQL queries in Athena?▼

You can save and reuse SQL queries in Athena by creating named queries. This feature streamlines repeatable analytics workflows, allowing you to quickly validate data patterns or generate insights across multiple datasets.

What is the best way to validate data patterns stored in S3?▼

The best way to validate data patterns in S3 is using Athena for interactive SQL querying. This serverless approach requires minimal setup, leveraging a Glue Data Catalog to quickly generate insights across large datasets.

Do I need a Glue Data Catalog to run Athena queries on S3?▼

Yes, a configured Glue Data Catalog is required to run Athena queries on S3. It provides the table schema definitions necessary for Athena to execute SQL-based analytics against your raw data stored in S3.

Related Skills

Explore More Data & Analytics Skills→
mreferremreferre

creating-data-lake-table

Create managed Iceberg tables on Amazon S3 Tables with Glue catalog registration.

Community
Advanced
JNZader-VaultJNZader-Vault

duckdb-analytics

Query Parquet files and S3 data lakes with DuckDB for OLAP analytics.

Official
Advanced
awslabsawslabs
15

s3

Optimizes Amazon S3 bucket configuration, access control, and lifecycle policies for secure, cost-effective storage management.

Official
Advanced
mreferremreferre

querying-data-lake

Execute Athena SQL queries across federated data lake catalogs with safety checks.

Community
Advanced