question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked Sumarigo-MSFT commented

Blob to snowflake table

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

azure-blob-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Sumarigo-MSFT avatar image
0 Votes"
Sumarigo-MSFT answered Sumarigo-MSFT commented

@RohitKulkarni-6062 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 134372-image.pngand “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


image.png (3.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.