Search code examples
macosterminalsnowflake-cloud-data-platformput

snowsql PUT command

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#[email protected]>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'.
Solution

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

    Try

    CBILONG#[email protected]>put file:///Users/Documents/users.csv @~/staged;