MSCEWI4022
PUT statement not supported on UI
Low
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.BULK INSERT #temptable FROM 'C:\Users\osalazar\Documents\Workspace\sql_samples\test.txt'
WITH
(
FIELDTERMINATOR ='\t',
ROWTERMINATOR ='\n'
);
/*** 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
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 1yr ago