Which copy options are not supported by CREATE PIPE…AS COPY FROM command?

Which copy options are not supported by CREATE PIPE…AS COPY FROM command?
A . FILES = ( ‘file_name1’ [ , ‘file_name2’, … ] )
B. FORCE = TRUE | FALSE
C. ON_ERROR = ABORT_STATEMENT
D. VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
E. MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE

View Answer

Answer: A,B,C,D,E

Explanation:

All COPY INTO <table> copy options are supported except for the following:

FILES = ( ‘file_name1’ [ , ‘file_name2’, … ] )

ON_ERROR = ABORT_STATEMENT

SIZE_LIMIT = num

PURGE = TRUE | FALSE (i.e. automatic purging while loading)

MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE

FORCE = TRUE | FALSE

Note that you can manually remove files from an internal (i.e. Snowflake) stage (after they’ve been loaded) using the REMOVE command.

RETURN_FAILED_ONLY = TRUE | FALSE

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes