Snowflake Documentation Home

Release Notes

Release notes for SnowConvert

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.

Version 1.1.33 (Aug 9, 2024)

Common

  • Fixed numerous SSC-EWI-0013 occurrences.

  • Improved UI experience when user does not have read/write permissions on a particular local directory.

Teradata

  • Added translation for PREPARE STATEMENT, ACTIVITY_COUNT, DAY_OF_MONTH, DAY_OF_WEEK, WEEK_OF_CALENDAR, MONTH_OF_CALENDAR.

  • Added translation for CREATE SCHEMA.

  • Fixed INTERVAL literal not migrated in minus operations.

  • Improved parser capability to read LATEST as a column name.

Oracle

  • Improved translation on PL/SQL parameter data types: VARCHAR and INTEGER.

  • Fixed duplicated comments in PL/SQL procedure declarations.

Version 1.1.26 (July 28, 2024)

Oracle

  • Add parsing of ACCESS PARAMETERS table options.

  • Add parsing of XMLType table.

  • Added translation for FUNCTION definition within anonymous blocks.

  • Fixed duplicated code SSC-FDM-OR0045.

  • Improve parsing of XMLSchema specification.

SQLServer

  • Fixed EXECUTE AS statement wrongly transformed to EXECUTE IMMEDIATE.

  • Fixed temporary table generated erroneously.

  • Improve parsing of WITH xmlnamespaces statement.

Version 1.1.16 (June 26, 2024)

Teradata

  • Fixed translation of LIKE NOT CASESPECIFIC.

  • Improved translation of variable declarations inside BEGIN…END.

  • Improved parsing of AS OF clause and WITH TIES option from CREATE VIEW.

Oracle

  • Fixed translation for columns with whitespaces in CREATE VIEW.

  • Improved description of SSC-EWI-OR0042.

  • Improved parsing of ACCESSIBLE BY clause and SQL_MACRO option from CREATE FUNCTION.

  • Improved parsing of the DECLARE statement.

SQLServer

  • Fixed translation of BEGIN…END showing pending functional equivalence.

  • Added translation for FOR XML PATH clause.

Version 1.1.9 (June 12, 2024)

Common

  • Added more info in the COMMENT clause of each object.

Teradata

  • Added an EWI 0073 to PREPARE statement.

  • Added OR REPLACE to CREATE TABLE

Oracle

  • Added translation for Materialized View's REFRESH_MODE property.

  • Improved parsing capability to read MODEL clause and to read CREATE VIEW alternate routes.

Version 1.1.8 (May 31, 2024)

Common

  • Added translation of Materialized View to Dynamic Tables.

  • Improved CodeUnit Report to show more code units.

SQLServer

  • Added translation of SET ANSI_NULLS.

  • Added translation of INSERT that contains a FROM Subquery + MERGE INTO pattern.

Version 1.1.6 (May 21, 2024)

Teradata

  • Fixed translation for Cast('POINT(x t)' As ST_GEOMETRY

  • Fixed translation of casting from one format to another.

  • Fixed translation related to DATEADD_UDF and TO_INTERVAL_UDF

Oracle

  • Improved parsing capability to read JSON_OBJECT and JSON_ARRAYAGG built-in functions.

SQLServer

  • Improved Missing Object References report's content.

  • Improved robustness during the semantic analysis phase and translation phase.

Version 1.1.5 (May 10, 2024)

Common

  • Provide more information and details for SSC-EWI-0001

  • Improved robustness of assessment mode when providing free tables.

Teradata

  • Improved translation related to date handling.

  • Improved parsing capability to read code that contains block comments.

  • Improved parsing capability to read NOT NULL column option before the data type declaration in a table.

  • Improved the functionality of TIMESTAMP_DIFFERENCE_UDF and EXTRACT_TIMESTAMP_DIFFERENCE_UDF.

SQL Server

  • Improved translation for ALTER TABLE CHECK constraint.

Version 1.1.4 (May 2, 2024)

Common

  • Added new breaking change at the UI. Now, the user will have to inquire about an access code for doing their assessment. For more details, please check here.

  • Added a new assessment report EmbeddedCodeUnitReport, for more information, please visit here.

  • Improved the TopLevelCodeUnitReport. Added four more columns: FDM Count, PRF Count, FDM and PRF. For more information, please visit here.

  • Fixed an unexpected error in creating an assessment report.

Teradata

  • Added translation for CONTINUE HANDLER.

  • Added new parsing capability for BYTE data type.

  • Improved binding variable translations.

Oracle

  • Added and improved parsing capability to read EXPLAIN PLAN statement, U-Literals and CTAS.

  • Improve CURSOR translation when it has to define a cursor with object_construct.

  • Improved translation of procedure parameters avoiding deployment errors.

SQLServer

  • Added translation for DB_ID function.

  • Added basic translation for CREATE SCHEMA.

  • Added an FDM for CREATE INDEX.

  • Improved ALTER TABLE translation.

Version 1.1.2 (April 24, 2024)

Included SnowConvert Core Version 28.1.113

Version 1.1.1 (April 19, 2024)

Included SnowConvert Core Version 28.1.100

Version 1.1.0 (Mar 26, 2024)

Included SnowConvert Core Versions

Version 1.0.3 (Mar 19, 2024)

Included SnowConvert Core Versions

PreviousRelease NotesNext2023 (Beta versions)

Last updated