What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The correct answer is A. The Pipe load history is reset to empty. When a pipe is recreated using the CREATE OR REPLACE PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe.

Data Loading and Unloading

Question

Options

AThe Pipe load history is reset to empty.
BThe REFRESH command is executed.
CThe stage will be purged.
DThe destination table is truncated.

How the community answered

(51 responses)

A
90% (46)
B
4% (2)
C
6% (3)

Explanation

When a pipe is recreated using the CREATE OR REPLACE PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe.

Topics

#Snowflake Pipes#CREATE OR REPLACE PIPE#Load History#Data Loading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice