
Explanation:
Based on the Snowflake documentation and the community discussion, when a pipe is recreated using CREATE OR REPLACE PIPE, the load history (metadata of previously loaded files) is reset to empty. This is explicitly stated in Snowflake's documentation: 'When a pipe is recreated, the load history is dropped.' Option B is incorrect because REFRESH is a parameter for ALTER PIPE, not CREATE OR REPLACE PIPE. Option C is misleading; while the load history is reset, previously loaded files are not automatically ignored unless specific actions like ALTER PIPE...REFRESH are taken, which could lead to duplicates. The most upvoted and well-reasoned comments (e.g., jjordan's with 27 upvotes) confirm A as correct, citing official docs. Thus, A is the optimal answer, aligning with documented behavior and community consensus.
Ultimate access to all questions.
When a pipe is recreated using the CREATE OR REPLACE PIPE command, what happens to the existing file load metadata that the previous pipe had loaded?
A
The Pipe load history is reset to empty
B
The REFRESH parameter is set to TRUE
C
Previously loaded files will be ignored
D
All of the above
No comments yet.