snowsql PUT command

Question

I'm trying to load user.csv file through snowsql Terminal on Mac and I get this error, and I know there is nothing wrong with the csv file

CBILONG#COMPUTE_WH@REVIEWS.PUBLIC>put file:///Macintosh HD\Users\Documents\users.csv @~/staged;
001003 (42000): SQL compilation error:                                          
parse error line 1 at position 25 near '85'.
parse error line 1 at position 31 near '68'.
parse error line 1 at position 41 near '117'.
syntax error line 1 at position 42 unexpected 'sers'.
syntax error line 1 at position 46 unexpected '.'.
syntax error line 1 at position 51 unexpected '@~/staged'.

user_1628812 · Answer

Looks like this is simply slash vs backslash issue and you don't need Macintosh HD in your path

Try

CBILONG#COMPUTE_WH@REVIEWS.PUBLIC>put file:///Users/Documents/users.csv @~/staged;

snowsql PUT command

1 Answers