16 Aug 19 · Keshava · #Snowflake ·   Bookmark   ×

Copy CSV file into Snowflake, The data itself has commas

I am loading data into a file through copy into command in snowflake. it is a CSV file and one of the column contain "," (comma) with in the data itself. How do we load such data into the table. Any ideas, please revert


posted on 16 Aug 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

npackAug 18 09:28

Can you try enclosing the data in double quotes in the file? For example:


and while running the copy command, use a file format like below,

// Create file format
create or replace file format CSV_SKIP_HEADER
type = 'CSV'
field_delimiter = ','
skip_header = 1;

Community Software by Hittly