Source
Migrating project definition files from version 1.x to 2.0
To convert a version 1.x project definition file to the version 2 format, do the following: Go to your project directory that contains the version 1.x snowflake.yml file. Enter the snow helpers v1 - to - v2 command.
snow helpers v1-to-v2
Migrates the Snowpark, Streamlit, and Native App project definition files from V1 to V2.
SnowConvert AI - BigQuery Issues
SnowConvert AI for Google BigQuery currently supports assessment and translation for TABLES and VIEWS. Although SnowConvert AI can recognize other types of statements, they are not fully supported.
SnowConvert AI - Redshift - CREATE TABLE
EXISTS is used in table creation commands to avoid errors if the table already exists. When included, it ensures that the table is created only if it does not already exist, preventing duplication and errors in your SQL script.
SnowConvert AI - IBM DB2 - CREATE TABLE
Specifies that the columns of the new table have the same name, data type, and optionally same data, as the resulting from the fullselect. Warning AS RESULT TABLE is partially supported in Snowflake. The Copy options do not apply in…
SnowConvert AI - Teradata - Built-in Functions
SnowConvert AI - Teradata - Built - in Functions This page provides a description of the translation for the built - in functions in Teradata to Snowflake Note This page only lists the functions that are already transformed by SnowConvert AI,…
SnowConvert AI - Redshift Issues
Set “configuration parameter” is not supported in Snowflake. Severity Medium Description The use of SET configuration parameter is not supported by Snowflake. For more information please refer to CREATE PROCEDURE documentation.
SnowConvert AI - Redshift Functional Differences
CREATE TABLE table1 ( col1 INTEGER SORTKEY (col1); CREATE TABLE table2 ( col1 INTEGER SORTKEY…
SnowConvert AI - Teradata - SQL to Snowflake Scripting (Procedures)
Teradata’s ABORT and ROLLBACK statements are replaced by a ROLLBACK statement in Snowflake Scripting.
SnowConvert AI - Oracle - Select
In this section you could find information about the select query syntax and its convertions. Note Some parts in the output codes are omitted for clarity reasons.