error while loading csv file though snlowsql copy into command

Question

i was trying to load csv file from AWS s3 bucket with copy into command in one of the csv file throw error like

End of record reached while expected to parse column '"RAW_PRODUCTS"["PACK_COUNT_UNITS":25]

and with the VALIDATION_MODE = RETURN_ALL_ERRORS it also give me 2 rows that have error i am not sure what error would be. my concern is can we get specific error so that we can fix it in file.

Perhaps there is some unicode characters, carriage return etc in the data that may be causing this? — Dean Flinter
– Dean Flinter, Commented Jul 6, 2021 at 12:15

Eda Johnson · Accepted Answer · 2021-07-06 13:01:48Z

2

You might try using the VALIDATE table function. https://docs.snowflake.com/en/sql-reference/functions/validate.html

answered Jul 6, 2021 at 13:01

Eda Johnson

891 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

nish71 · Accepted Answer · 2021-07-07 10:23:48Z

0

Thanks Eda, i already reviewed above link but that did not work with sql query with copy into table from s3 bucket, so i create stage and place that csv file on stage and then try to run that validate command that give me same error row. there is another way to identify error while executing copy into command you can add VALIDATION_MODE = RETURN_ALL_ERRORS you will get same result.

by the way i resolve error its due to /,, i remove / and it loaded successfully. / or /, is working as it was in other row but /,, did not work.

answered Jul 7, 2021 at 10:23

nish71

2751 silver badge7 bronze badges

Collectives™ on Stack Overflow

error while loading csv file though snlowsql copy into command

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related