Recent Release Notes
Release notes for SnowConvert
Version 1.11.1 (July 2, 2025)
New Features 🚀
Support for new Snowflake Out Arguments syntax within Snowflake Scripting on Teradata, Oracle, SQL Server, and Redshift migrations.
Fixes 🛠️
Enhanced Teradata Data Type Handling: JSON to VARIANT migration.
Improved recovery on Redshift procedures written with Python.
Version 1.11.0 (July 2, 2025)
New Features 🚀
New Data Validation framework integration for SQL Server End-to-End experience: Now, users can validate their data after migrating it. The Data Validation framework offers the following validations:
Schema validation: Validate the table structure to attest the correct mappings among datatypes.
Metrics validation: Generate metrics of the data stored in a table, ensuring the consistency of your data post-migration.


The framework also generates a new report, clearly indicating whether differences were found or the validation was successful for the table or column where it was applied.

Version 1.10.0 (June 24, 2025)
New Features 🚀
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Tables.
Translation of Views.
Translation of Data Types.
Translation of Built-in Functions.
Version 1.9.0 (June 20, 2025)
New Features 🚀
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Tables.
Translation of Views.
Translation of Data Types.
Translation of Built-in Functions.
Translation for common Language Elements.
Improvements 📈
Support for ARRAY type in tables.
Support for Timezone built-in function.
Support for ANY & ALL array expression.
Parsing support for Geometry data type.
Support for External Tables.
Version 1.8.0 (June 6, 2025)
New Features 🚀
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Regular Tables.
Translation of Views.
Translation of SELECT.
Translation of Data Types.
Translation of Built-in Functions.
Version 1.7.1 (June 2, 2025)
General
Version 1.7.0 (May 30, 2025)
New Features 🚀
Locate the Power BI reports in a folder and apply restrictively the extension of a template .pbit.
In the SnowConvert app, add the path of the Power BI projects in the ETL-BI section.
For more information please visit the documentation page for Power BI Repointing
Version 1.6.1 (May 26, 2025)
Fixed
Improved mechanism to rename objects and usages using renaming feature.
Version 1.6.0 (May 19, 2025)
New Features 🚀
General
End-to-End Migration Experience for Redshift & SQL Server SnowConvert now offers a fully integrated, end-to-end migration workflow for Amazon Redshift and Microsoft SQL Server users, enabling a seamless transition to Snowflake within a single tool. This new experience encompasses the entire migration lifecycle:
Direct Source Connectivity & Object Extraction:
New: Enabled direct connections to Redshift and SQL Server databases from within the SnowConvert interface.
New: Users can now extract a comprehensive range of database objects (including Tables, Views, Stored Procedures, Functions, etc.) directly within the new unified flow.
In-Flow Object Renaming:
New: Integrated functionality to rename extracted database objects prior to the conversion phase, providing greater flexibility within the migration pipeline.
Deployment:
New: Added the capability to deploy the converted Snowflake code directly to the target environment from SnowConvert.
Integrated Data Migration:
New: Users can now perform data migration from the source Redshift or SQL Server database to Snowflake as the final step of the migration process, all orchestrated within SnowConvert. This completes the full migration journey in a single, cohesive experience.
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Regular and Temporary Tables.
Translation of Views.
Translation of Materialized Views.
Translation of Data Types.
PostgreSQL Support (Preview)
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Regular and Temporary Tables.
Translation of Views.
Translation of Materialized Views.
Translation of Data Types.
Version 1.5.1 (May 13, 2025)
New Features 🚀
General
Significantly improved the Object References reports by fixing multiple false-positive scenarios.
BigQuery
Improved conversion of anonymous struct definition.
New supported Built-in Functions.
Oracle
Updated the
TO_NUMBER
function transformation to support theDEFAULT VALUE ON CONVERSION ERROR
option and fix runtime errors when trying to convert an empty string.The
LAG
function will display an FDM when a default value is provided, cautioning that the function may fail due to data type mismatch between the default and the expression.
Version 1.5.0 (April 24, 2025)
Sybase IQ Support For Views (Preview)
SnowConvert now supports the conversion of Views to Snowflake. This feature includes support for the following:
Translation for SELECT statement.
Translation for Built-in Functions
Greenplum Support (Preview)
SnowConvert now supports the conversion of Tables and Views to Snowflake. This feature includes support for the following:
Translation of Regular and Temporary Tables.
Translation of Views.
Translation of Materialized Views.
Translation of Data Types.
Google BigQuery (Preview)
SnowConvert now supports the conversion of Google BigQuery Views to Snowflake and built-in functions.
Translation of Views.
Translation of Built-in functions.
Aggregate Functions
ANY_VALUE
, AVG
, COUNT
, COUNTIF
, LOGICAL_AND
, LOGICAL_OR
, MAX
, MIN
, SUM
Conditional Expressions
COALESCE
, IF
, IFNULL
, NULLIF
Conversion Functions
SAFE_CAST
Date Functions
CURRENT_DATE
, FORMAT_DATE
Datetime Functions
CURRENT_DATETIME
Geography Functions
ST_GEOGFROMTEXT
, ST_GEOGPOINT
JSON Functions
JSON_VALUE
, JSON_EXTRACT_SCALAR
Mathematical Functions
ABS
, LEAST
, MOD
, ROUND
Navigation Functions
FIRST_VALUE
, LAG
, LEAD
, LAST_VALUE
Numbering Functions
RANK
, ROW_NUMBER
String Functions
CHARACTER_LENGTH
, CHAR_LENGTH
, CONCAT
, FROM_BASE64
, FROM_HEX
, LEFT
, LENGTH
, LOWER
, LPAD
, LTRIM
, STARTS_WITH
, REPLACE
, RIGHT
, RPAD
, RTRIM
, SPLIT
, SUBSTR
, SUBSTRING
, UPPER
Timestamp Functions
CURRENT_TIMESTAMP
SnowConvert now supports the conversion of user-defined functions to Snowflake.
Translation of User-Defined Functions.
New Features 🚀
General
Added Deployment Order column to Top-Level Code Units and Embedded Code Units reports.
Version 1.4.1 (April 10, 2025)
Google BigQuery Support (Preview)
SnowConvert now supports the conversion of Google BigQuery Tables to Snowflake. This feature includes support for the following:
Translation of Regular and Temporary Tables
Translation of External Tables
Translation of Snapshot tables.
Translation of Table CLONE, LIKE, and COPY.
Translation of Data Types.
New Features 🚀
General
New supported System Default (Preview) encoding value.
Support of System Default (Preview) encoding. It attempts to automatically detect the file encoding or to use the default system encoding (more details here).
We've added a wide range of translation support for Amazon Redshift's built-in functions.
Aggregate Functions
ANY_VALUE
, LISTAGG
, MEDIAN
, PERCENTILE_CONT
, STDDEV
, STDDEV_POP
, STDDEV_SAMP
, VAR_POP
, VAR_SAMP
, VARIANCE
Array Functions
ARRAY
, ARRAY_CONCAT
, ARRAY_FLATTEN
, GET_ARRAY_LENGTH
, SPLIT_TO_ARRAY
, SUBARRAY
Conditional Expressions
DECODE
, NVL2
Date and Time Functions
ADD_MONTHS
, TIMESTAMP (AT TIME ZONE)
, CURRENT_DATE
, DATE_PART_YEAR
, LAST_DAY
, NEXT_DAY
, SYSDATE
Math Functions
ACOS
, ASIN
, ATAN
, ATAN2
, CBRT
, CEIL
, CEILING
, COS
, COT
, DEGREES
, DEXP
, DLOG1
, DLOG10
, EXP
, FLOOR
, LN
, LOG
, MOD
, PI
, POWER
, POW
, RADIANS
, RANDOM
, SIN
, SIGN
, SQRT
, TAN
String Functions
ASCII
, CHARACTER_LENGTH
, CHARINDEX
, CHR
, INITCAP
, LEN
, OCTET_LENGTH
, REPEAT
, REPLICATE
, REVERSE
, SOUNDEX
, STRPOS
, TEXTLEN
, TRANSLATE
SUPER Type Information Functions
IS_ARRAY
, IS_BOOLEAN
Window Functions
FIRST_VALUE
, LAG
, LAST_VALUE
, LISTAGG
, MEDIAN
, NTH_VALUE
, NTILE
, PERCENT_RANK
, PERCENTILE_CONT
, PERCENTILE_DISC
, RATIO_TO_REPORT
, STDDEV_SAMP
, STDDEV_POP
, STDDEV
, VAR_SAMP
, VAR_POP
Version 1.3.0 (Mar 25, 2025)
Sybase IQ Support (Preview)
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)
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)
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.
Cursor Operations:
Support for the FETCH statement.
Transformation for refcursor variable declaration.
DML Operations:
Transformations for INSERT, DELETE, UPDATE, MERGE, SELECT INTO 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.
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 toEXECUTE 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 andWITH TIE
S option fromCREATE VIEW
.
Oracle
Fixed translation for columns with whitespaces in
CREATE VIEW
.Improved description of
SSC-EWI-OR0042
.Improved parsing of
ACCESSIBLE BY
clause andSQL_MACRO
option fromCREATE 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
toCREATE 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
andTO_INTERVAL_UDF
Oracle
Improved parsing capability to read
JSON_OBJECT
andJSON_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
Last updated