SnowConvert: Recent Release Notes¶

Version 1.3.0 (Mar 25, 2025)¶

Sybase IQ Support¶

SnowConvert now supports the conversion of Sybase IQ Create Table to Snowflake. This feature includes support for the following:

New Features 🚀¶

Sybase:
- Translation of Regular and Temporary Tables
- Translation of Constraints
- Translation of Data Types

Azure Synapse¶

Fix Object References not shown in Object References and Missing Object References reports.
Added parsing support for Materialized Views with distribution clause

Version 1.2.17 (Mar 18, 2025)¶

Azure Synapse Support¶

SnowConvert is adding support for Azure Synapse to Snowflake, now enabling direct translation for Azure Synapse SQL scripts and stored procedures to Snowflake’s SQL dialect. This complements our existing support for Transact-SQL (T-SQL) and provides a more comprehensive solution for users migrating from Microsoft’s data warehousing ecosystem.

New Features 🚀¶

Common:
- Add a Relation Type column to the Object References and Missing Object References reports.

Version 1.2.16 (Mar 10, 2025)¶

Redshift Stored Procedures Support¶

SnowConvert now supports the conversion of Redshift stored procedures to Snowflake, enabling seamless migration of procedural code. This feature includes support for variable operations, control flow statements, cursor handling, and transaction management capabilities.

New Features 🚀¶

Stored procedures new supported functionality.

General support:
- Transformation for SELECT INTO variables inside stored procedures.
- Transformation for CASE statements without ELSE clauses.
- Transformation of RETURN statement in Redshift.
- Support of RAISE for logging, warnings, and exceptions.
Variable Binding:
- Support for binding variables in stored procedures.
- Handling positional arguments for binding variables.
- Variable bindings in the OPEN cursor statement.
Transaction Support:
- Initial support for COMMIT, ROLLBACK, and TRUNCATE statements.
Cursor Operations:
- Support for the FETCH statement.
- Transformation for refcursor variable declaration.
DML Operations:
- Transformations for INSERT, UPDATE, MERGE, SELECT INTO statements.
**Control Flow Statements**:
- Support for basic control flows statements.
- Transformations of Labels Stats against loops.
DDL Operations:
- Support for CREATE TABLE AS statement.

Breaking Changes ⛓️‍💥¶

Renamed Code Unit Name to Code Unit ID in Top-Level Code Units report.

Version 1.2.6 (Feb 26, 2025)¶

Oracle¶

Fixed CONSTRAINT clauses incorrectly reported as parsing errors.

Redshift¶

Added

Support for Declare statement.
Support for Merge statement.
Support for Update statement.
Support for variable declaration with Refcursor type.
Support for Declare, Open and Close Cursor.

Teradata¶

Fixed ‘chars’, and ‘characters’ built-in functions being reported as missing references.

Version 1.2.5 (Feb 7, 2025)¶

Common¶

Improved SnowConvert CLI help messages.

Version 1.2.4 (Feb 7, 2025)¶

Common¶

Improved SnowConvert CLI help messages.

Teradata¶

Improved EWI consistency on DATE casting.

Version 1.2.1 (Jan 31, 2025)¶

Common¶

Fixed

Improved mechanism to validate the Snowconvert license by preventing the use of the powershell current user profile settings, ensuring a smoother execution.

Version 1.2.0 (Jan 28, 2025)¶

Free access for anyone with a corporate email.
Redshift conversion is now supported under preview.
Remove assessment step. Assessment and conversion are now completed in only one step.
Introduction of the new Code Completeness Score and Code Unit Methodology.
Improved messages like Functional Difference Messages (FDMs), Performance Reviews (PRFs) and EWIs (error, warnings, and issues).

Common¶

Fixed

Usage of correlated scalar subqueries erroneously causing SSC-EWI-0108 under certain scenarios.

Teradata¶

Fixed

Set Character Set as optional in description of columns in derived tables.

Version 1.1.91 (Dec 19, 2024)¶

Common¶

Fixed

Correlated scalar subqueries missing an aggregate function.
Uncorrelated scalar subqueries are being marked as unsupported.

Teradata¶

Added¶

Added “ANSI/TERA Session Mode” and “Use COLLATE for Case Specification” settings:
- ANSI mode with COLLATE.
- ANSI mode without COLLATE.
- TERA mode with COLLATE.
- TERA mode without COLLATE.
Support parsing of GENERATED TIMECOLUMN column option.
Support parsing of TD_NORMALIZE_MEET function.\

Fixed¶

Fixed inconsistencies in column names when it comes to Snowflake reserved keywords.
Parsing errors in PARTITION BY RANGE_N clause.
Improved support for COALESCE expression.

SQL Server¶

Fixed¶

Some functions were incorrectly marked as a pending functional.

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.

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 converted 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

SQL Conversion Core: 28.1.78

Version 1.0.3 (Mar 19, 2024)¶

Included SnowConvert Core Versions

SQL Conversion Core: 28.1.20