What Snowflake recommendation is designed to ensure that staged data is only loaded once"?

Question

Options

• APartitioning staged data files
• BLoading only the most recently-staged data files
• CRemoving data files after loading
• DIdentifying and removing duplicates after each data load

• A
  4% (1)
• C
  88% (23)
• D
  8% (2)

Explanation

Snowflake's best practice is to remove data files from the stage immediately after they have been successfully loaded. While Snowflake tracks load history for files (preventing duplicate loads within a 64-day metadata retention window), files can still be reloaded if the FORCE option is used or after the metadata expires. Deleting files post-load is the definitive safeguard. Partitioning staged files (A) improves load performance but doesn't prevent reloading. Loading only the most recently staged files (B) is not a reliable deduplication strategy. Identifying duplicates after loading (D) is a reactive fix, not a preventive recommendation.

No community discussion yet for this question.