Links

MSCEWI2073

Bash variables found, using SnowSQL with variable substitution enabled is required to run this script

Severity

Low

Description

When the source code of a script file migrated to Snowflake Scripting contains Bash variables placeholders ($variable or ${variable}), SnowConvert transforms them into SnowSQL variables (&variable or &{variable}).
This warning is generated to point out that the execution of the migrated script now depends on SnowSQL to work, please consider the following when running the script in SnowSQL:

Example Code

Input Code:

.LOGON dbc, dbc;
select '$variable', '${variable}', '${variable}_concatenated';
select $colname from $tablename where info = $id;
select ${colname} from ${tablename} where info = ${id};
.LOGOFF;

Output Code:

EXECUTE IMMEDIATE
$$
--** MSC-WARNING - MSCEWI2073 - BASH VARIABLES FOUND, USING SNOWSQL WITH VARIABLE SUBSTITUTION ENABLED IS REQUIRED TO RUN THIS SCRIPT **
BEGIN
/*** MSC-ERROR - MSCEWI1037 - TRANSLATION FOR SCRIPT STATEMENTS IS PLANNED TO BE DELIVERED IN THE FUTURE ***/
/*.LOGON dbc, dbc;*/
SELECT
'&variable',
'&{variable}',
'&{variable}_concatenated';
SELECT
&colname
from
PUBLIC.&tablename
where
info = &id;
SELECT
&{colname}
from
PUBLIC.&{tablename}
where
info = &{id};
/*** MSC-ERROR - MSCEWI1037 - TRANSLATION FOR SCRIPT STATEMENTS IS PLANNED TO BE DELIVERED IN THE FUTURE ***/
/*.LOGOFF;*/
END
$$

Recommendations