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 2< hour mark?
A.
The file will continue to load until all contents arc loaded.
B.
The tile will slop loading and all data up to that point will be committed.
C.
The file loading could be aborted without any portion of the file being committed.
D.
The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake
When attempting to load large files, such as a 125 GB file, into Snowflake using SnowSQL, the process might encounter limitations related to the maximum execution time for queries or data loading operations. If the loading process exceeds this time limit (typically around 24 hours), it could be aborted without committing any part of the file to the database. This behavior is designed to prevent indefinite resource consumption and to maintain system stability, emphasizing the need for optimizing data load operations, possibly through file segmentation or parallel loading strategies.References: Snowflake Documentation on Data Loading Considerations
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit