Query Amazon S3 Tables from Amazon EMR Trino using the Iceberg REST endpoint

This article demonstrates how to query Amazon S3 Tables from Amazon EMR Trino using the Apache Iceberg REST endpoint for managed analytics without operational overhead.

• Amazon S3 Tables provides automated Iceberg table maintenance including compaction and snapshot expiration
• Trino on Amazon EMR offers distributed SQL query engine with low-latency interactive access to large datasets
• Apache Iceberg REST catalog specification enables standardized integration across different compute engines
• CloudFormation template automates deployment of VPC, EMR cluster, and S3 Tables integration
• Trino catalog configuration uses REST endpoint with AWS Signature Version 4 authentication for secure access
• Supports advanced features including time travel queries and schema evolution on S3 Tables
• Architecture separates compute and storage for independent scaling and cost efficiency

This solution provides operational simplicity, performance at scale, and open-standards-based analytics without vendor lock-in for modern data lakehouses.