When using the COPY INTO [table] command with the CSV file format, how does the MATCH_BY_COLUMN_NAME parameter behave?
When using the COPY INTO [table] command with the CSV file format, how does the MATCH_BY_COLUMN_NAME parameter behave?
When using the COPY INTO [table] command with the CSV file format, if the MATCH_BY_COLUMN_NAME parameter is used, the command will return an error. This is because the parameter specifies that the column names in the CSV file should match the column names in the target table, and any mismatch or the absence of the expected headers will lead to an error.
correct answer is C https://community.snowflake.com/s/article/COPY-INTO-table-Command-MATCH-BY-COLUMN-NAME-Copy-Option-Returns-Error-When-Loading-CSV-Data
Since option A isn't true unless the parameter is set to CASE_SENSITIVE and CSV column name detection is in Open Private Preview only , the correct answer here should be C
When MATCH_BY_COLUMN_NAME is specified, Snowflake expects the first row of the CSV file to contain column headers. Snowflake then matches these column headers (which are case-sensitive) with the column names in the target table. The matching is done based on the order and names of the columns in the CSV file header and the target table. If a column in the CSV file header does not match any column in the target table, it may cause an error or a warning, depending on other parameters and settings.