MSC-PG0018

Select with Into clause is not compatible with snowflake, it is transformed to a Create Table As And unlogged is not compatible with snowflake, all transactions are logged.

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

Severity

Low

Description

Select Into is not compatible with Snowflake, this functionality was imitated with a Create Table As. And Snowflake always uses transaction logs to protect tables and ensure data integrity and recoverability. Therefore, tables with the UNLOGGED option are not allowed in Snowflake.

Code Example

Input Code:

PostgreSQL

select column1
      into UNLOGGED NewTable
      from OldTable;

Output Code:

Snowflake

CREATE OR REPLACE TABLE NewTable AS
      select column1
-- ** MSC-WARNING - MSC-PG0018 - SELECT WITH INTO CLAUSE IS NOT COMPATIBLE WITH SNOWFLAKE, IT IS TRANSFORMED TO A CREATE TABLE AS AND UNLOGGED IS NOT COMPATIBLE WITH SNOWFLAKE, ALL TRANSACTIONS ARE LOGGED. **
--            into UNLOGGED NewTable
            from
            OldTable;

For more information please refer to Select Into.

Recommendations

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