Catalog And Query

---
name: catalog-and-query
description: "Guides awswrangler Glue Catalog, Athena, Data Quality, and AWS
  Clean Rooms workflows."
disable-model-invocation: true
metadata:
  disco-role: operating
license: Apache 2.0
---

# Catalog and Query

Use this sub-skill when the user is working with `wr.catalog.*`, `wr.athena.*`, `wr.data_quality.*`, or `wr.cleanrooms.*` workflows.

Typical triggers:
- "create a Glue table"
- "register a parquet dataset for Athena"
- "run an Athena query"
- "use CTAS or UNLOAD"
- "manage Athena prepared statements"
- "create or evaluate a data quality ruleset"
- "read from AWS Clean Rooms"

Read `references/api-reference.md` for the function map and public signatures.
Read `references/workflows.md` for the common end-to-end query and metadata flows.
Read `references/troubleshooting.md` for Athena, Glue, Data Quality, and Clean Rooms failure modes.
Use `../../scripts/check_runtime.py` from the root skill when you need to check importability, extras, or engine mode before a workflow.

## Include here

- Glue Catalog database, table, partition, and schema helpers.
- Athena query execution, result handling, CTAS, UNLOAD, prepared statements, table inspection, and Spark-on-Athena helpers.
- Glue Data Quality ruleset creation, update, retrieval, recommendation, and evaluation.
- AWS Clean Rooms SQL query execution and query waiting.

## Exclude or route elsewhere

- S3 object movement, read/write, S3 Tables, Delta Lake, and S3 Vectors go to `s3-lakehouse`.
- Redshift, Data API, and direct relational connectors go to `sql-connectors`.
- Runtime, extras, and distributed execution questions go to `runtime-and-config`.
- DynamoDB, Timestream, OpenSearch, Neptune, QuickSight, CloudWatch, EMR, STS, Secrets Manager, and Chime go to `service-integrations`.

## Common user outcomes

A future agent should be able to:
- register S3-backed datasets in Glue,
- inspect and evolve catalog metadata,
- build and run Athena queries with the right output location and workgroup,
- manage data quality rulesets,
- and handle Clean Rooms query execution with the right membership and output settings.

## Shared references and scripts

- `references/api-reference.md`
- `references/workflows.md`
- `references/troubleshooting.md`
- `scripts/smoke_catalog_moto.py`