A
A
agreIT2020-12-22 13:48:02
Command line
agreIT, 2020-12-22 13:48:02

EOF error when parsing a snowsql query, what should be checked?

There is a command:

sudo -H -u snowuser /var/snowflake/bin/snowsql --config /.snowsql/local_config -q 'CREATE OR REPLACE FILE FORMAT CSV TYPE = '\''CSV'\'' FIELD_DELIMITER = '\'','\'' ESCAPE = '\''\\'\'' SKIP_HEADER = 0 RECORD_DELIMITER = '\''\r\n'\'' FIELD_OPTIONALLY_ENCLOSED_BY = '\''"'\'''  -o header=false -o timing=true -o friendly=false -o log_level=DEBUG

When running locally, it throws an error:
syntax error line 2 at position 0 unexpected '' FIELD_OPTIONALLY_ENCLOSED_BY = ''.
parse error line 2 at position 36 near '<EOF>'.


On EC2, the command completes successfully. What needs to be installed or in which direction to look (on the server)?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question