snowflake : copy into statement

snowflake-cloud-data-platform

the help notes:

VALIDATION_MODE does not support COPY statements that transform data during a load. If the parameter is specified, the COPY statement returns an error.

Which implies you are doing some form of JSON/Variant data processing in the COPY statements select. Which is valid without VALIDATION_MODE = 'RETURN_ERRORS'

So can you copy the data into a staging table, and do zero JSON process, to "just have raw data" which in a second command to merge/insert into a processed form?

Related

Replace multi-line string in terminal
Where do I find the bashrc file on Mac?
How to get cURL to output only HTTP response body (JSON) and no other headers etc
Warning: findDOMNode is deprecated in StrictMode. findDOMNode was passed an instance of Transition which is inside StrictMode
Devise - How do I forbid certain users from signing in?
Javascript Object push() function
What does the Subversion status symbol "~" mean?
Indenting #defines
How to use nonnull and nullable Objective-C keywords in block-based API method
ALTER TABLE without locking the table?
Why does git keep telling me it's "Auto packing the repository in background for optimum performance"?
Why does csvwriter.writerow() put a comma after each character?