Is there a way to variabilize folder paths in SnowSQL for commands like put and copy where I could do
put $file_location
Or even
put file:$file_location
Instead of
put file://R:\testing\data\take_1.txt
Variabilizing folder path in SnowSQL
Viewed 93
1 Answers
You could use define:
> !define file_location=path_goes_here
> !set variable_substitution=true
> put &file_location
Substituting Variables in a Session
To use a variable in a statement, use the &variable_name syntax. Note that variable names are case-insensitive.
...
To combine a variable with text, enclose the variable reference in curly braces.
select '&{snowshell}_shell';
Related