MSC-PG0017

Select with Into clause is not compatible with snowflake, it is transformed to a Create Table As.

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.

Code Example

Input Code:

PostgreSQL

select column1
      into NewTable
      from OldTable;

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;

For more information please refer to Select Into.

Recommendations

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