DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ51

VerifiedOfficial exam objectives/topics

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

What action should the Engineer take to view the changed data without duplicating data?

Explanation

Snowpipe maintains load metadata for each pipe using a file’s path and name, preventing a previously loaded file from being loaded again even when it has been modified. Using new file names for the changed data allows Snowpipe to ingest the changes as new files without reloading the original files and duplicating their data.

Learn more

Community Discussion

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