id,title,year,text
1,t1,1998,"abcd"
2,c,1999,"abcdef"
3,d,1989,"xyz"
These are my contents in csv file. I want to load them in snowflake. I tried various approach like setting like below :
CREATE OR REPLACE FILE FORMAT double_slash_q1
TYPE = 'CSV'
FIELD_OPTIONALLY_ENCLOSED_BY = '"'
ESCAPE_UNENCLOSED_FIELD = NONE
ESCAPE = '\'
SKIP_HEADER = 1
TRIM_SPACE = TRUE;
but they don’t work. Let me know what can be the solution?
1