Skills
.Work. You
Rest

Athena Query Patterns

Community

Optimize AWS Athena queries.

Data & Analytics#query optimization#aws#data analysis#sql#athena#partition pruning
AuthorFrancisVarga
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides best practices and example queries for efficiently querying data in AWS Athena, focusing on cost optimization and performance.

Core Features & Use Cases

  • Partition Pruning: Demonstrates how to use partition columns (event_type, dt) in WHERE clauses to drastically reduce data scanned and costs.
  • Common Query Patterns: Offers SQL examples for event counts, member activity analysis, error reporting, game popularity, and more.
  • Temporal Analysis: Includes patterns for week-over-week and year-over-year comparisons.
  • Cost Optimization: Details techniques like column pruning and pre-aggregation.
  • Use Case: When writing a new Athena query, consult this Skill to ensure partition pruning is applied and to find a relevant pattern for your analytical goal, thereby minimizing query costs and execution time.

Quick Start

Use the athena-query-patterns skill to find an example SQL query for analyzing daily event counts.

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: Athena Query Patterns
Download link: https://github.com/FrancisVarga/stupid-db/archive/main.zip#athena-query-patterns

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 223,000+ vetted skills library on demand.