SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ64

VerifiedImplement Data Pipelines

A Data Engineer modified staged files and staged them again. A pipe is running, but the updated data is not showing up in the table.

What should the Engineer do to view the updated data without creating duplicate data?

Explanation

Snowpipe prevents duplicate loads by tracking filenames in metadata associated with the pipe object, so a re-staged file with the same name is ignored even if its contents changed. Snowflake documents recreating the pipe with CREATE OR REPLACE PIPE as the necessary method to reload modified data files.

Learn more

Community Discussion

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