Câu 23: SnowPro Advanced Architect
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in the following error:SQL compilation error: invalid parameter 'validation_mode'Assuming the syntax is correct, what is the cause of this er…
Nội dung câu hỏi
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in the following error:SQL compilation error: invalid parameter 'validation_mode'Assuming the syntax is correct, what is the cause of this error?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.
- B. The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.
- C. The VALIDATION_MODE parameter does not support COPY statements that transform data during a load. — đáp án hiện tại
- D. The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.