While attempting to avoid data duplication, which COPY INTO
While attempting to avoid data duplication, which COPY INTO
To avoid data duplication while loading files with expired load metadata, the correct option to use is LOAD_UNCERTAIN_FILES. This option allows the system to reference load metadata if available to avoid duplicates, while also attempting to load files with expired load metadata.
To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true. The copy option references load metadata, if available, to avoid data duplication, but also attempts to load files with expired load metadata.
A is correct
Answer is A
A correct - https://docs.snowflake.com/en/user-guide/data-load-considerations-load
B correct - 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. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table
wrong - it will create dups Alternatively, set the FORCE option to load all files, ignoring load metadata if it exists. Note that this option reloads files, potentially duplicating data in a table.
sorry, found it https://docs.snowflake.com/en/user-guide/data-load-considerations-load A correct