Additional resources

For a CREATE TABLE AS example that creates both bucketed and partitioned tables, see Example: Creating bucketed and partitioned tables.

For information on implementing bucketing on AWS data lakes, including using an Athena CTAS statement, AWS Glue for Apache Spark, and bucketing for Apache Iceberg tables, see the AWS Big Data Blog post Optimize data layout by bucketing with Amazon Athena and AWS Glue to accelerate downstream queries.