Source
SnowConvert AI - SQL Server-Azure Synapse Functional Differences
This message is shown when there is a collate clause that is not supported in Snowflake.
SnowConvert AI - General Issues
This issue occurs when there is an error while parsing the source code that is being converted. It means there is a source code syntax error or a specific statement of the code is not being recognized yet.
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 - Redshift - SQL Statements
Runs a stored procedure. The CALL command must include the procedure name and the input argument values. You must call a stored procedure by using the CALL statement.
SnowConvert AI - SQL Server-Azure Synapse Issues
This EWI appears when SnowConvert AI handles a critical exception that causes the function body not to be generated during its translation.
SnowConvert AI - General Functional Differences
This message is reported when a Correlated Subquery (subquery that refers to a column from the outer query) is located. This type of subqueries can, in some cases, present some functional differences in Snowflake (Working with Subqueries).
SnowConvert AI - Redshift Functional Differences
Data storage is automatically handled by Snowflake. Description In Snowflake, it is not necessary to explicitly define SORTKEY and DISTSTYLE when migrating from Redshift because Snowflake’s architecture inherently manages data…
SnowConvert AI - Oracle - Built-In packages
Translation reference for Built - in packages. Description Oracle supplies many PL/SQL packages with the Oracle server to extend database functionality and provide PL/SQL access to SQL features.
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 - SQL Server-Azure Synapse - CREATE PROCEDURE (Snowflake Scripting)
Snowflake SQL, a transaction can be started explicitly by executing a BEGIN statement. Snowflake supports the synonyms BEGIN WORK and BEGIN TRANSACTION. Snowflake recommends using BEGIN TRANSACTION. A transaction can be ended explicitly by…