STORAGE.ICEBERG_TARGET_FILE_SIZE

Target database: Snowflake

STORAGE.ICEBERG_TARGET_FILE_SIZE option enables:

User to define the desired target file size.


See also:


Usage

STORAGE.ICEBERG_TARGET_FILE_SIZE: String

Default: empty

As of 23.6.2026 the possible options are:

  • AUTO

  • 16MB

  • 32MB

  • 64MB

  • 128MB


Notes

Supports only Snowflake Iceberg table.


Examples

Snowflake: Enable the STORAGE.ICEBERG_TARGET_FILE_SIZE

Setting STORAGE.ICEBERG_TARGET_FILE_SIZE to 16MB for an Iceberg table (e.g. publish.F_TRIP):

STORAGE.ICEBERG_TARGET_FILE_SIZE: 16MB

DDL generated by Agile Data Engine:

SQL
CREATE ICEBERG TABLE publish.F_TRIP (
    ...
)
...
TARGET_FILE_SIZE = '16MB'
...
;