Snowflake-Internal Stage data load error: How to load "" character

Question

In a file, few of the rows have in a column value for example, i have rows in below format.

1. 101,Path1,Z:VMCPSPS,abc

2. 102,Path5,C:wintmPSPS,abc

I was wondering how to load character

COPY INTO TEST_TABLE from @database.schema.stage_name FILE_FORMAT = ( TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = '"' SKIP_HEADER = 1 ); 

is there any thing that i can mention the file_format line?

question from:https://stackoverflow.com/questions/66055806/snowflake-internal-stage-data-load-error-how-to-load-character

Answer 1

Waitting for answers