MSC-PG0016

The lock level is handled automatically in Snowflake.

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

Severity

Low

Description

Snowflake maintains transactional consistency and allows non-blocking reads by using isolated transactional snapshots, rather than row locks, to manage data access.

Code Example

Input Code:

PostgreSQL

select column1
      into NewTable
      from OldTable
      For UPDATE;

Output Code:

Snowflake

CREATE OR REPLACE TABLE NewTable AS
      select column1
-- ** MSC-WARNING - MSC-PG0017 - SELECT WITH INTO CLAUSE IS NOT COMPATIBLE WITH SNOWFLAKE, IT IS TRANSFORMED TO A CREATE TABLE AS. **
--            into NewTable
            from
            OldTable
-- ** MSC-WARNING - MSC-PG0016 - THE LOCK LEVEL IS HANDLED AUTOMATICALLY IN SNOWFLAKE. **
--            For UPDATE
                      ;

For more information please refer to The Locking Clause.

Recommendations

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