MSCEWI4022

PUT statement not supported on UI

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This EWI is added when a BULK INSERT was transformed and a PUT command is added to the output code. It happens because the PUT command cannot be executed using the SnowSQL Web UI. In order to successfully execute it, any user should has the SnowCLI installed before.

Code Example

Input Code:

BULK INSERT #temptable FROM 'C:\Users\osalazar\Documents\Workspace\sql_samples\test.txt'  
WITH   
(  
   FIELDTERMINATOR ='\t',  
   ROWTERMINATOR ='\n'
); 

Output Code:

/*** MSC-WARNING - MSCEWI4022 - PUT STATEMENT IS NOT SUPPORTED ON WEB UI. YOU SHOULD EXECUTE THE CODE THROUGH THE SNOWFLAKE CLI ***/
PUT file://C:\Users\osalazar\Documents\Workspace\sql_samples\test.txt @STAGE_637692072327877197 AUTO_COMPRESS = FALSE;

COPY INTO PUBLIC.T_temptable FROM @STAGE_637692072327877197/test.txt

Recommendations

• Visit the SnowSQL CLI user guide.

• If you need more support, you can email us at [email protected]