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.
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.
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.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
romega2
Highly Voted 1 year, 2 months agoPrasantSadangi
Most Recent 2 months, 2 weeks agoGudref
11 months, 2 weeks agoshanksund
1 year, 2 months agoHeetec
1 year, 2 months agoHeetec
1 year, 2 months agoromega2
1 year, 2 months agoHeetec
1 year, 2 months ago