Rules and Guidelines for Snowflake Data Cloud file ingestion tasks
Rules and Guidelines for Snowflake Data Cloud file ingestion tasks
When you configure a file ingestion task to write to Snowflake Data Cloud from the supported file ingestion sources, you must specify a batch size for the maximum number of files to be transferred in a batch. Specify a value for the batch size in the required source properties of the file ingestion task. When you specify a batch size, the performance of the task is optimized.
The default batch size is 5. When you write from Amazon S3 or Azure Blob Storage sources to a Snowflake target, you can specify a maximum batch size of 1000 in the Amazon S3 or Azure Blob Storage source properties. For other file ingestion supported sources, you must specify a batch size between 1 and 20.