Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?
Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?
The correct command to use is FORCE = TRUE. This option forces the COPY command to load all files regardless of whether their load status is known or not.
To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.
FORCE = TRUE when load status is known LOAD_UNCERTAIN_FILES = TRUE when load status is unknown
FORCE=TRUE
A is correct. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.
Workarounds 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.
A is correct