CODEWITHSUNDEEP
snowflake-cloud-data-platform
DarkSpark
DarkSpark

Reputation: 123

COPY INTO SNOWFLAKE IGNORE "/"

I wish to upload a file with field with text containing "\", but to ignore it while running COPY INTO.

e.g: For the following field value: \"before!!\' not!!

I wish the data be loaded as : "before!!' not!!

I have tried including ESCAPE='\\', Tried using FIELD_OPTIONALLY_ENCLOSED_BY='"', and ESCAPE_UNENCLOSED_FIELD in all kind of variations, None of those options did the job.

Does anyone have any idea?

Thanks!

Upvotes: 0

Views: 518

Answers (1)

NickW
NickW

Reputation: 9768

If you want to change the values of a field then you would need to do it as part of the SELECT statement e.g. using the REPLACE function.

This is documented here

Upvotes: 1

Related Questions