Amazon Athena now supports CREATE TABLE AS SELECT with Amazon S3 Tables
News
Amazon Athena now supports CREATE TABLE AS SELECT (CTAS) statements with Amazon S3 Tables, enabling users to easily create and populate new tables from query results.
- CTAS allows converting datasets in Parquet, CSV, JSON, and other formats into fully-managed tables
- Supports Apache Iceberg, Hudi, and Delta Lake formats
- Enables on-the-fly data partitioning for optimized query performance
- Allows users to analyze data, JOIN with other datasets, and perform INSERT and UPDATE operations
- Available in all AWS Regions that support Athena and S3 Tables
This feature streamlines data management by simplifying table creation and optimization in a single SQL statement.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Aug 15
2025
2025
Transform your data to Amazon S3 Tables with Amazon Athena
Mar 13
2025
2025
Amazon S3 Tables add create and query table support in the S3 console
Jan 30
2025
2025
Amazon S3 Tables add schema definition support to the CreateTable API
Aug 16
2019
2019
Amazon Athena now supports querying data from Amazon S3 Requester Pays Buckets
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.