Assign snowsql select query output to an unix variable

Question

how do we assign SNOWSQL select query output to an unix variable, i am using below shellscript and trying to assign the output of select statement to variable var2. but somehow it is not working.

#!/bin/ksh set var2=(snowsql -c newConnection -o log_level=DEBUG -o log_file=~/snowsql_sso_debug.log -r DEV_ACCT_ROLE -w LOAD_WH -d DEV_DB -s CTL_DB -q "select STG_TBL_NAME from CTL_DB.PROC_CTRL WHERE STG_TBL_NAME='TEAM'")

appriciate your quick response. Thanks

Glad to hear that. In this case, could you mark the answer as correct? so other people knows that the question is answered. — Gokhan Atil
– Gokhan Atil, Commented Nov 30, 2020 at 11:26

Gokhan Atil · Accepted Answer · 2020-11-30 11:14:00Z

3

I can get the result using $(), but you should also use some additional options to suppresses header, timing, and the startup and exit messages.

https://docs.snowflake.com/en/user-guide/snowsql-config.html#snowsql-configuration-options-reference

VAR2=$(snowsql -c myconnection -q "SELECT max(v) FROM Z" -o friendly=False -o header=False -o output_format=plain -o timing=False)

echo $VAR2
20200210

answered Nov 30, 2020 at 11:14

Gokhan Atil

10.6k2 gold badges13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dovregubben Over a year ago

in more recent versions of snowsql you will have to add -o echo=False, otherwise your SQL query will be returned as well

Collectives™ on Stack Overflow

Assign snowsql select query output to an unix variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related