Blob to snowflake table

Question

Hello Team,

I am trying to upload the data file from Blob to Snowflake table :

COPY INTO Table1
FROM 'azure://Blobstorage.blob.core.windows.net/Folder/file1.csv'
FILE_FORMAT = (TYPE = 'csv' FIELD_OPTIONALLY_ENCLOSED_BY = '"' SKIP_HEADER = 1 ) ON_ERROR='Continue'

Total rows : 40935
Total uploaded:40931
error :4

The 4 rows didn't uploaded into the table :

I got error saying :Found character 'A' instead of record delimiter '\n'

Please advise.

Regards
RK

Answer 1

@Rohit Kulkarni Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

This is thread explains, most common cause of this error is that field value contains the delimiter https://community.snowflake.com/s/article/Copy-Error-Message-Field-delimiter-found-while-expecting-record-delimiter-n

Also you can try to get rid of linespace in csv, Ex: FIELD_OPTIONALLY_ENCLOSED_BY ='"' worked and data was loaded.

If the issue still persist, I would recommend to please post your query in Snowflake Community for receiving insights from the right set of experts. based on your scenario .

Please let us know if you have any further queries. I’m happy to assist you further.

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Please do not forget to and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators