Question

A data engineer used the PUT command to upload three CSV files to their user stage. They now want to load only one specific file, sales_west.csv, into the WEST_SALES table using a predefined file format named CSV_FMT. Which COPY INTO statement correctly loads just that single file from the user stage?

Accepted Answer

COPY INTO WEST_SALES FROM @~/sales_west.csv FILE_FORMAT = (FORMAT_NAME = 'CSV_FMT');

Answer

COPY INTO WEST_SALES FROM @%WEST_SALES/sales_west.csv FILE_FORMAT = (FORMAT_NAME = 'CSV_FMT');

Answer

COPY INTO WEST_SALES FROM @sales_west.csv FILE_FORMAT = (FORMAT_NAME = 'CSV_FMT');

Answer

COPY INTO WEST_SALES FROM '@~/sales_west.csv' PATTERN = 'CSV_FMT';