Which command successfully loads data into the table named finance_dept_location?
finance_dept_location
Snowflake supports loading selected staged-file columns through a COPY INTO ... FROM (SELECT ...) transformation. A transformation cannot use WHERE or LIMIT, and VALIDATION_MODE is unsupported for transformed COPY loads and performs validation rather than loading data.
COPY INTO ... FROM (SELECT ...)
WHERE
LIMIT
VALIDATION_MODE
Community Discussion