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?
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.
CREATE OR REPLACE PIPE
Community Discussion