SnowflakeDocumentation Home

Release Notes

Release notes for SnowConvert

Version 1.1.80 (Dec 5, 2024)

Common

Fixed

  • SnowConvert was incorrectly marking scalar subqueries as invalid when some function aliases were used.

  • Crash when SnowConvert didn't have read/write permissions to configuration folder.

Teradata

Fixed

  • Renaming feature now contemplates function with parameters.

  • The UPDATE statement with ELSE INSERT syntax was not converted correctly.

SQL Server

Fixed

  • SnowConvert now successfully converts @@ROWCOUNT using the global variable SQLROWCOUNT.

  • View and column names from sys objects are now be paired with INFORMATION_SCHEMA.

Version 1.1.69 (Nov 14, 2024)

SQL Server

Fixed

  • BIT Datatype with DEFAULT value is not converted to true or false but 1 or 0.

Oracle

Fixed

  • Code missing when converting a function with CONNECT BY.

Version 1.1.67 (Oct 30, 2024)

Teradata

Fixed

  • Flag TeraModeForStirngComparison is set to true as default.

SQL Server

Fixed

  • Columns with default value are now converted correctly with their respective data type casting.

Oracle

Fixed

  • Code missing when converting a function with CONNECT BY.

Version 1.1.63 (Oct 24, 2024)

Common

  • Recovery codes removed from the parsing error messages.

  • Windows close button now works as intended.

  • Added a new field domain to the comment clause for each DDL SnowConvert generates.

Teradata

Added

  • Support for UNION ALL clause with different data types and column sizes.

  • Support for sp_executeql.

Fixed

  • Inconsistencies in string comparison in Tera mode and ANSI mode.

  • Complex column alias with syntax ''n is not being recognized by SnowConvert.

SQL Server

Added

  • FDM in every corelated subquery.

Fixed

  • Issue with WITH DISTRIBUTION and CLUSTERED in table creation.

Oracle

Fixed

  • Issue that caused SP conversion to fail when using .rownum within a FOR statement.

Version 1.1.61 (Oct 18, 2024)

Teradata

Fixed

  • Conversion of stored procedures inside macros is now supported.

  • StringSimilarity Teradata Function is now converted successfully

Oracle

Fixed

  • DATEDIFF_UDF now returns date difference with timestamp as parameter with decimals (time part difference).

1.1.56 (Oct 9, 2024)

Teradata

Fixed

  • Create a Stored Procedure to compliance the same flow as in Teradata (StoredProcedure inside a Macro)

  • Use a UDF Helper to emulate the functionality given for a VALIDTIME column in Teradata

Oracle

Fixed

  • Empty Create Statement

  • Return date difference with timestamp as parameter with decimals (time part difference).

Version 1.1.54 (Oct 3, 2024)

Common

  • Improved the auto-update mechanism.

Teradata

Fixed

  • UDF called “PERIOD_TO_TIME_UDF" is now included as part of the code output if it is used in the converted code.

  • UDF called “DATE_TO_PERIOD_UDF" is now included as part of the code output if it is used in the converted code.

SQL Server

Fixed

  • The CLUSTERED clause is no longer in the output code.

Oracle

Fixed

  • PARTITION clause in queries is now identified as an EWI instead of FDM.

Version 1.1.52 (Sep 24, 2024)

Common

  • Adding an informative message when there is no communication to the licensing API and a link with more information of what is happening.

  • A new column named "Lines of Code" was added on the report, specifically the “2.1 Conversion Rates Summary" table

Teradata

Fixed

  • Cast to CHAR/CHARACTER causing parsing error

SQL Server

Fixed

  • Empty STAT EWI when there is an extra ';'.

  • Continue statement is not marked as an EWI any more.

Oracle

Fixed

  • DATE_TO_RR_FORMAT_UDF is now included on the output if there is a reference to it on the input source code.

Version 1.1.45 (Sep 12, 2024)

Common

Fix Encoding issue SSC-EWI-0041

Teradata

Added

  • New conversion setting for TERA MODE strings comparison transformation

Fixed

  • Anonymous block of code converted to a stored procedure.

  • PRIMARY TIME INDEX not being parsed.

SQL Server

Fixed

  • Empty stat should not be classified as pending functional

  • SQL report has a text referring to Teradata

Oracle

Added

  • Oracle function conversion to Functions (single statement)

Fixed

  • DATE_TO_RR_FORMAT_UDF is added in the view conversion but is not part of the SC output

Version 1.1.38 (Aug 29, 2024)

Common

  • Improved the performance for running SnowConvert.

Teradata

  • Added translation for EXTRACT function.

  • Fix translation in procedure when there is a presence of IMMUTABLE/VOLATILE.

  • Improved translation of EXTRACT_TIMESTAMP_DIFFERENCE_UDF to support timestamp as parameter.

SQL Server

  • Improved error handling when translating long-named columns.

Oracle

  • Added translation for STANDARD_HASH function.

  • Improved the parser to be able to read DBMS_DATAPUMP.detach.