How can a Snowflake user load duplicate files with a COPY INTO command?
How can a Snowflake user load duplicate files with a COPY INTO command?
To load duplicate files with the COPY INTO command in Snowflake, the COPY INTO option should be set to FORCE = TRUE. This setting instructs Snowflake to load all files, regardless of whether they have been loaded previously and have not changed since they were last loaded. This could lead to duplicating data in the table.
B is correct.
CORRECT is B FORCE parameter avoid snowflake duplicate files check in historic of files loaded.
correct
B is correct
https://docs.snowflake.com/en/user-guide/snowsql-config If enabled, SnowSQL forces the PUT command to upload (i.e. stage) data files from a local directory/folder on a client machine to the specified internal (i.e. Snowflake) stage without checking whether the files already exist in the stage. If the files are already present in the destination stage, the PUT command overwrites the existing files.
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table FORCE = TRUE | FALSE Definition Boolean that specifies to load all files, regardless of whether they’ve been loaded previously and have not changed since they were loaded. Note that this option reloads files, potentially duplicating data in a table.