View all questions & answers for the ARA-C01 exam
When using the copy into <title> command with the CSV file format, how does the match_by_column_name parameter behave?
It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.
The parameter will be ignored.
The command will return an error.
The command will return a warning stating that the file has unmatched columns.
https://community.snowflake.com/s/article/COPY-INTO-table-Command-MATCH-BY-COLUMN-NAME-Copy-Option-Returns-Error-When-Loading-CSV-Data
Submit