# Amazon Athena introduces system tables for query execution observability

DevFeed: [Amazon Athena introduces system tables for query execution observability](<https://devfeed.tech/articles/amazon-athena-introduces-system-tables-for-query-execution-observability-126343.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/big-data/amazon-athena-introduces-system-tables-for-query-execution-observability/>)

Author: Pathik Shah

Published: 2026-11-09T18:06:44Z

Content type: release

Language: en

Sources: [AWS Big Data Blog](<https://devfeed.tech/sources/aws-big-data-blog.md>)

Topics: [Amazon S3 Tables](<https://devfeed.tech/topics/amazon-s3-tables.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [observability](<https://devfeed.tech/topics/observability.md>), [AI for SQL query generation](<https://devfeed.tech/topics/ai-for-sql-query-generation.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agent-skill](<https://devfeed.tech/tags/agent-skill.md>), [agent-toolkit](<https://devfeed.tech/tags/agent-toolkit.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agent](<https://devfeed.tech/tags/ai-agent.md>), [amazon-athena](<https://devfeed.tech/tags/amazon-athena.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [attribution](<https://devfeed.tech/tags/attribution.md>), [audit](<https://devfeed.tech/tags/audit.md>), [capacity](<https://devfeed.tech/tags/capacity.md>), [cost](<https://devfeed.tech/tags/cost.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [metadata](<https://devfeed.tech/tags/metadata.md>), [observability](<https://devfeed.tech/tags/observability.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pipelines](<https://devfeed.tech/tags/pipelines.md>), [sql](<https://devfeed.tech/tags/sql.md>), [trends](<https://devfeed.tech/tags/trends.md>)

## AI overview

Amazon Athena's new `query_executions` system table records each completed query, including failures, with identity, workgroup, timing, data scanned, DPU count, and outcome details. Enable system tables in the Athena console; records become queryable within minutes as Apache Iceberg data in an S3 Tables bucket in your account. Athena manages table maintenance, while you control encryption, access, and retention; no default retention is set. The table supports cost attribution, performance trends, audit, error analysis, and capacity reservation analysis. Data is read-only for account principals and can also be queried by Iceberg-compatible engines. For natural-language exploration, AWS describes using an MCP-compatible agent with the Athena system tables skill and read-only IAM access; the skill provides schemas and partition-aware query examples.

## Source excerpt

Amazon Athena now offers system tables: SQL-queryable, per-query execution metadata stored as Apache Iceberg in your own account. This post walks through what system tables are, how to turn them on, and how to use them for usage analysis, cost attribution, performance trends, audit, and capacity optimization without custom pipelines.