SnowConvert: PostgreSQL Functional Differences
FOUND could have a different behavior in Snowflake in some scenarios. Severity Low Description The FOUND property in PostgreSQL is a property based on the last executed query, it can be affected by some statements such as INSERT, UPDATE,…
SnowConvert: Oracle Functional Differences
This functionality allows for a customized traversal of the data, ensuring that the results are returned in a specific sequence based on the specified criteria. It is important to note, however, that this behavior, characterized by the…
SnowConvert:PL/SQL to Snowflake Scripting
SnowConvert:PL/SQL to Snowflake Scripting ASSIGNMENT STATEMENT Description The assignment statement sets the value of a data item to a valid value. (Oracle PL/SQL Language Reference ASSIGNMENT Statement) Note Some parts in the output code…
SQL Server to Snowflake Migration Guide
Data migration involves transferring data between different storage systems, formats, or computer systems. In the context of a SQL Server to Snowflake migration, it specifically refers to moving data from your SQL Server environment to…
SnowConvert: Transact-SQL Functional Differences
This message is shown when there is a collate clause that is not supported in Snowflake.
SnowConvert: 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…
Writing stored procedures in Snowflake Scripting
Snowflake limits the maximum size of the source code in the body of a Snowflake Scripting stored procedure. Snowflake recommends limiting the size to 100 KB. (The code is stored in a compressed form, and the exact limit depends on…
SQL Server to Snowflake Translation with SnowConvert
Example: DECIMAL(10,2) in SQL Server becomes NUMBER(10,2) in Snowflake. String Types: VARCHAR, NVARCHAR, CHAR, and NCHAR map to Snowflake’s VARCHAR and CHAR. TEXT and NTEXT (deprecated in SQL Server) map to Snowflake’s VARCHAR (with…
Snowflake counterparts of SQL functions
FAQ: The following table lists the SQL scalar functions that are supported in Snowflake, as well as their Snowflake equivalents.
Query Data in Snowflake
Snowflake supports standard SQL, including a subset of ANSI SQL:1999 and the SQL:2003 analytic extensions. Snowflake also supports common variations for a number of commands where those variations do not conflict with each other. Tip You…
Source