Copy CSV file into Snowflake, The data itself has commas

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

id,text1,text2
1,"1,2,3","cat"

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 = ','
  FIELD_OPTIONALLY_ENCLOSED_BY = '"'
  skip_header = 1;