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
user.csv
snowsql
CBILONG#COMPUTE_WH@REVIEWS.PUBLIC>put file:///Macintosh HDUsersDocumentsusers.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'.
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;
1.4m articles
1.4m replys
5 comments
57.0k users