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?

Question

Options

• AThe file will continue to load until all contents arc loaded.
• BThe tile will slop loading and all data up to that point will be committed.
• CThe file loading could be aborted without any portion of the file being committed.
• DThe file's number of allowable hours to load can be programmatically controlled to load easily into

• A
  5% (1)
• B
  5% (1)
• C
  90% (19)

Explanation

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.

No community discussion yet for this question.