MSCEWI3131

COMMIT and ROLLBACK statements require adequate setup to perform as intended

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

Severity

Low

Description

COMMIT and ROLLBACK statements require adequate setup to perform as intended in Snowflake. The following instruction needs to be executed in Snowflake to simulate the correct functionality of these statements:

ALTER SESSION SET AUTOCOMMIT = false;

Example Code

Input Code

COMMIT;
ROLLBACK;

Output Code

/*** MSC-WARNING - MSCEWI3131 - COMMIT REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED ***/
COMMIT;

/*** MSC-WARNING - MSCEWI3131 - ROLLBACK REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED ***/
ROLLBACK;

Recommendations

• Execute the query mentioned in the description section before you start to execute your code.

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