April 13, 2026: Dynamic Apache Iceberg™ tables now support PARTITION BY, TARGET_FILE_SIZE, and PATH_LAYOUT (General availability)¶

Dynamic Apache Iceberg™ tables now support the following table properties:

• PARTITION BY: Partition the table using Iceberg partition expressions such as identity, bucket, truncate, year, month, day, and hour transforms.

• TARGET_FILE_SIZE: Control the target Parquet file size for table writes. Defaults to AUTO, which lets Snowflake choose the optimal file size.

• PATH_LAYOUT: Choose between a flat or hierarchical (Hive-style) directory layout for data files. Use HIERARCHICAL together with PARTITION BY to write data to partition-aware paths.

For more information, see Configure partitioning, file size, and path layout and CREATE DYNAMIC ICEBERG TABLE.