February 19-21, 2024 — 8.7 Release Notes (with behavior changes)
Collation allows you to specify alternative rules for comparing strings, which can be used to compare and sort data according to a particular language or other user - specified rules.
SnowConvert: General Functional Differences
Views that select all columns from a single table without any filtering conditions (WHERE clause) are unnecessary in Snowflake and can negatively impact query performance.
SnowConvert: SQLServer Issues
This warning appears when an unsupported time component is used as a parameter in a date - related function in Snowflake. For a complete list of supported date and time components, please refer to the Date & Time Functions | Snowflake…
SnowConvert: Teradata SQL to Snowflake Scripting (Procedures)
Teradata’s ABORT and ROLLBACK statements are replaced by a ROLLBACK statement in Snowflake Scripting. For more information on Teradata ABORT and for ROLLBACK.
February 12-14, 2024 — 8.6 Release Notes
Given a GEOGRAPHY column, returns a GEOGRAPHY object that represents the shape containing the combined set of points that are common to the shapes represented by the objects in the column, such as the intersection of the shapes.