SnowConvert AI – Informationen

SnowConvert AI is an AI-powered Snowflake utility that accurately converts source database code from other platforms to Snowflake.

It ingests scripts for the source database objects such as tables, views, stored procedures, and functions. These scripts are then converted into Snowflake SQL scripts to recreate the exact equivalent Snowflake database objects. After reviewing the converted code, you can deploy the Snowflake SQL scripts on an existing instance of Snowflake.

Database platforms differ in syntax, built-in and procedural language features, logical architecture, SQL extensions, data types, and the extent of user defined customizations. SnowConvert AI intelligently detects these differences and flags them as errors, warnings, issues (EWIs), and functional difference messages (FDMs). These can be resolved manually or by using the built AI Code Conversion feature. The AI Code Conversion feature also creates test cases to verify that the functionality of the converted Snowflake SQL code is exactly the same as the source database code.

Users can deploy the converted and verified code in an existing Snowflake instance.

SnowConvert AI – Wichtige Funktionen

Quelltechnologie

Verfügbarkeit

Unterstützte Codekonvertierung

Quell-DB-Verbindung

Datenmigration

Snowflake-Bereitstellung

AI Code Conversion

Teradata

GA

Tables, views, stored procedures, functions, Basic Teradata Query (BTEQ), Teradata MultiLoad (MLOAD), Teradata Parallel Data Pump (TPUMP)

Extraction script

Nein

Nein

Nein

Oracle

GA

Tables, views, stored procedures, functions, packages

Extraction script

Nein

Nein

Nein

SQL Server

GA

Tables, views, stored procedures, functions

Extraction script, direct DB connection

Ja

Ja

Ja

Redshift

GA

Tables, views, stored procedures, functions

Extraction script, direct DB connection

Ja

Ja

Ja

Azure Synapse

GA

Tables, views, stored procedures, functions

Extraction script

Nein

Nein

Nein

Sybase IQ

GA

Tables, views, stored procedures, functions

Extraction script

Nein

Nein

Nein

Google BigQuery

GA

Tables, views

Extraction script

Nein

Nein

Ja

Greenplum

GA

Tables, views

Nein

Nein

Nein

Nein

Netezza

GA

Tables, views

Nein

Nein

Nein

Nein

PostgreSQL

GA

Tables, views

Nein

Nein

Nein

Ja

Spark SQL

GA

Tables, views

Nein

Nein

Nein

Nein

Databricks SQL

GA

Tables, views

Nein

Nein

Nein

Nein

Vertica

GA

Tables, views

Nein

Nein

Nein

Nein

Hive

GA

Tables, views

Nein

Nein

Nein

Nein

IBM-DB2

GA

Tables, views, stored procedures, functions

Nein

Nein

Nein

Nein

For more information, contact snowconvert-info@snowflake.com.