A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.
What will happen at the 24-hour mark?
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.
What will happen at the 24-hour mark?
If a data loading operation continues beyond the maximum allowed duration of 24 hours, it could be aborted without any portion of the file being committed. Therefore, the file loading could be aborted without any data being committed if it surpasses the 24-hour mark.
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare Note Loading very large files (e.g. 100 GB or larger) is not recommended. If you must load a large file, carefully consider the ON_ERROR copy option value. Aborting or skipping a file due to a small number of errors could result in delays and wasted credits. In addition, if a data loading operation continues beyond the maximum allowed duration of 24 hours, it could be aborted without any portion of the file being committed. https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
Answer - C