athena-queries

Query Athena telemetry tables and export filtered results from Glue catalogs.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/asimihsan/dotfiles --skill athena-queries
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: athena-queries
Source: https://github.com/asimihsan/dotfiles/tree/main/chezmoi/dot_claude/skills/athena-queries
Command: npx skills add https://github.com/asimihsan/dotfiles --skill athena-queries

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the complexity and manual effort of running AWS Athena queries against telemetry data, debugging partitions, and exploring Glue catalogs. It streamlines data analysis and troubleshooting, saving you time and reducing errors.

Core Features & Use Cases

  • Execute SQL Queries: Run queries against telemetry-parser-db (raw Parquet) or telemetry_alerts (DBT-transformed tables).
  • Glue Catalog Exploration: Easily list databases, tables, and retrieve schema details for Glue Data Catalog.
  • Query Workflow Management: Automate the full query lifecycle: start execution, poll for completion, and download results.
  • Use Case: Quickly diagnose a data anomaly by querying raw telemetry logs for a specific day and hour, then downloading the results for further analysis, all through a guided, automated process.

Quick Start

Run an Athena query to select the top 10 rows from the telemetry_lock table for '2025-11-09' at '02' hour in the platform-prod environment.

Frequently Asked Questions about athena-queries

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

FAQPage Schema
How do I query AWS Athena against telemetry data in Parquet format?

Query Athena directly against raw Parquet data stored in telemetry-parser-db or DBT-transformed tables in telemetry_alerts. Start execution, poll for completion, and export results—all automated within your environment workgroup.

Can I explore the Glue Data Catalog and debug partitions without manual SQL?

Yes. List databases, retrieve table schemas, and filter by the $path pseudo-column to debug partitions across dev, stage, and prod environments using predefined workgroups and IAM profiles.

How do I automate the full Athena query workflow from execution to result download?

Automate start-query-execution, poll for completion status, and download results in one workflow. Partition-aware execution ensures efficient querying of large telemetry datasets across environments.

What's the fastest way to diagnose a telemetry data anomaly?

Query raw telemetry logs for a specific date and hour, then download results for analysis. Guided, automated workflow eliminates manual query setup and error-prone steps.

Does this work with DBT-transformed views and signals queries?

Yes. Query both raw Parquet data and DBT-transformed views and signals in telemetry_alerts using the same partition-aware execution within us-west-2 across all environments.

Can I query across dev, stage, and prod without switching credentials or workgroups?

Yes. Environment-specific workgroups and IAM profiles handle credential and query configuration automatically, eliminating manual environment switching.