DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ49

VerifiedOfficial exam objectives/topics

A table is loaded through Snowpipe and subsequently truncated. Later, a Data Engineer determines that the table must be reloaded, but the pipe metadata prevents the same files from being loaded again.

How can this problem be resolved with the least operational overhead?

Explanation

Snowpipe stores file-loading history in the pipe object, and truncating the target table does not remove that history. Recreating the pipe with CREATE OR REPLACE PIPE removes the pipe-associated file-load metadata, allowing the files to be loaded again. FORCE = TRUE is not supported in a Snowpipe pipe definition, while waiting for metadata expiry or modifying and restaging files requires more operational effort.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!