The number of load operations that run in parallel cannot exceed the number of data files to be loaded.

• A. False
• B. True
• C. Only for certain warehouses
• D. Depends on file size

Answer: (B)

Parallel loading is driven by how many files you have to load. Each parallel loader works on a single file, so you can’t have more concurrent load operations than the number of data files staged for the load. If you have, say, five files, Snowflake can run up to five loaders in parallel (subject to warehouse capacity). If there are fewer files, some parallel slots stay idle. This behavior is consistent across warehouses and isn’t dictated by file size.