SnowConvert AI - Recent Release Notes¶

SSIS¶

• SSIS Replatform migration (Public Preview) - SnowConvert AI now supports SSIS package migration to Snowflake in Public Preview, enabling automated conversion of SSIS workflows to modern cloud-native data pipelines.

BigQuery¶

• Added support for the JSON_TYPE built-in function.

• Added support for the SAFE.POW function.

• Added transformation for array slice patterns.

• Added more array pattern support.

IBM DB2¶

• Added support for CONTINUE HANDLER.

Oracle¶

• Added support for the PARTITION clause in MERGE statements.

RedShift¶

• Added support for CONTINUE HANDLER.

Teradata¶

• Added support for CONTINUE HANDLER.

PowerBI¶

• Added the HierarchicalNavigation flag as an optional parameter in native connectors.

Oracle¶

• Enhanced arithmetic operations with TIMESTAMP values.

SSIS¶

• Enhanced the UI for the SSIS Replatform Public Preview release with improved user experience and workflow optimization.

General¶

• Updated Mobilize.Snow.CodeProcessor and related components to version 31.9.15.

• Removed the SSC-EWI-0009 warning from non-literal expressions and added FDM instead.

• AiVerification - Added support for n_tests parameter in configuration file.

BigQuery¶

• Fixed an issue where UDF files were not generated.

General¶

• Fixed an issue where symbols were not loaded in views and set operations.

General¶

• Fixed incorrect verified objects count calculation during validation process.

• Updated warehouse validation error messages to maintain consistency with connector messaging.

BigQuery¶

• Added support for REGEXP_EXTRACT_ALL and ROW_NUMBER built-in functions.

• Added support for the ARRAY built-in function.

SQL Server¶

• Migrated XACT_STATE to CURRENT_TRANSACTION.

• Enabled ROLLBACK transformation within explicit transactions.

PowerBI¶

• Improved the ‘Pending Work Description’ on repointing reports.

General¶

• Updated Mobilize.Snow.CodeProcessor and related components.

BigQuery¶

• Fixed an issue where literals inside IN UNNEST were not being transformed.

• Fixed SAFE_CAST behavior when the input type is not VARCHAR.

General¶

• Fixed queries containing aggregate functions and multiple columns.

BigQuery¶

• Added support for the REGEXP_REPLACE function.

• Added support for the FORMAT function with the %t argument.

• Added support for the BYTE_LENGTH function.

• Added support for the TIMESTAMP_TRUNC function.

Teradata¶

• Improved the preservation of default values in SELECT INTO statements for empty results.

PowerBI¶

• Improved M-Query source retrieving from metadata files.

General¶

• The Mobilize.Snow.CodeProcessor and related components have been updated to version 31.8.12.

PowerBI¶

• Fixed an issue where the parameter list was not read correctly when the connection pattern was rejected.

• Added description in ETLAndBiRepointing assessment report when non-database or non-applicable connectors are unmodified.

BigQuery¶

• Added support for TimestampDiff, Safe_Divide, and Except functions.

• Added support for the ARRAY_AGG function.

• Added the UNNEST built-in symbol.

• Added support for the UNIX_SECONDS built-in function.

• Added support for UNIX_MILLIS and UNIX_MICROS built-in functions.

• Added support for ARRAY_CONCAT, TIMESTAMP_MILLIS, and ENDS_WITH functions.

• Added support for JSON_QUERY, JSON_EXTRACT, JSON_QUERY_ARRAY, and JSON_EXTRACT_ARRAY functions.

Teradata¶

• Added support for .REMARK in SnowScript.

SSIS¶

• Implemented SSIS ForEach File Enumerator translation logic.

Tableau¶

• Added repointing assessment for Tableau repointing.

General¶

• Added support for the MD5 function.

Teradata¶

• Commented out ERROR LEVEL in BTEQ.

SSIS¶

• Enhanced identifier sanitization for SSIS.

• Improved retrieval of the “CopyFromReferenceColumn” property for output columns in SSIS Lookup.

General¶

• Added account information to AiVerification logs.

• Added warehouse validation to the Snowflake login.

• Updated Mobilize.Snow.CodeProcessor and related components.

• Wrapped control variable values with TO_VARIANT in UpdateControlVariable calls.

• Refactored SQL task creation to use CREATE OR REPLACE syntax.

• Added INSERT...SELECT with TO_VARIANT for control variables.

• Added transformation for string case-insensitive comparisons.

General¶

• Fixed name collisions of tasks in the main control flow with container tasks.

• Fixed “No expression translation for negative numbers (or unary ‘minus’)” issues.

BigQuery¶

• Support was added for the TO_HEX and ARRAY_TO_STRING_FUNCTION.

Oracle¶

• SnowScript UDF is now generally available.

SQL Server¶

• SnowScript UDF is now generally available.

General¶

• A feature flag was added to hide additional options for the AiVerification API.

• An interface was added to Abstract Syntax Trees (ASTs) for representing string comparisons.

• Partial support was added for the ARRAY_CONCAT_AGG function.

• Support was added for the REGEXP_EXTRACT function.

• Transformation support was added for the UNNEST function within an IN predicate.

• Support was added for the NET.IPV4_TO_INT64 function.

SSIS¶

• Added core foundation for ForEach File Enumerator.

• Added base infrastructure for Dynamic SQL.

• Added cursor-based iteration structure for SSIS ForEach Loop containers.

• Added dynamic SQL support for SSIS Execute SQL Task.

Oracle¶

• Added support for the BigQuery UNNEST operator.

• Added support for JSON_VALUE_ARRAY built-in function.

• Added support for multiple built-in functions.

• Added support for TIMESTAMP_SECONDS.

• Added support for SnowScript UDF.

SQL Server¶

• Added TSqlSetIdentityInsertReplacer to handle SET IDENTITY_INSERT in Transact.

General¶

• Added AI Verification PuPr Followup items.

• Added ‘connection’ element in Tableau repointing.

• Added semicolons to execute SQL task statements inside containers.

• Added transformation for NET.SAFE_IP_FROM_STRING function.

• Added support for HLL_COUNT.MERGE function.

• Added support for NET.IP_NET_MASK function.

• Added ETL Preprocess Task.

• Added transformation for HLL_COUNT.INIT function.

• Added support for offset array accessor function.

Teradata¶

• Fixed issues related to CAST formats.

Oracle¶

• Fixed an issue where supported formats were incorrectly marked as unsupported.

• Fixed a bug related to symbol key creation.

General¶

• Fixed an issue with symbol key creation when loading symbols with context.

• Fixed an issue with quotes and value length in Tableau repointing.

General¶

• Added support for Snowflake select asterisk column expressions.

SSIS¶

• Added support for converting CAST expressions.

General¶

• Enhanced the SnowflakeLogin method to handle email users correctly.

• Updated core libraries to versions 31.0.141.

• Moved the Declare Statement Replacer to SQL.

SSIS¶

• Fixed an issue where SSIS containers BEGIN END without a semicolon.

Oracle¶

• Fixed an issue with incorrect function transformation.

• Fixed an issue where SYS_REFCURSOR was not being migrated correctly.

dbt¶

• Fixed an issue with conditional split downstream ref() calls.

PowerBI¶

• Expanded test scenarios for Teradata Power BI repointing.

SSIS¶

• Introduced support for the SSIS Merge Join transformation.

• Implemented orchestrator task variable wrappers for SSIS tasks.

Teradata¶

• Ensured script files are now correctly reported as code units when Snowscript is the target.

Oracle¶

• Implemented a warning system for users when a referenced datatype might be unsupported.

• Renamed RAISE_MESSAGE_UDF.sql to RAISE_MESSAGE.sql for clarity and consistency.

SQL Server¶

• Added parameters as an identifier for improved recognition.

dbt¶

• Relocated configuration files to the ETL output directory and removed analyses and snapshots folders from dbt projects.

General¶

• Added transformations for BTEQ labels to support nested procedures.

• Enabled result binding for the Execute SQL Task.

• Included Migration ID in object tagging and relevant reports for enhanced telemetry.

• Reduced the frequency of the AI Verification prompt.

Oracle¶

• Enhanced the conversion process for %TYPE declarations.

• Refactored DB2 variable declarations for improved consistency.

General¶

• Updated core libraries to versions 31.0.134.

• Improved collision detection and resolution mechanisms for ETL transformations.

Oracle¶

• Resolved an issue where RAISE_MESSAGE_UDF.sql was incorrectly referenced in PostgreSQL tests.

• Addressed a problem where EWI (Error Warning Information) was not being added to unresolved types in Oracle.

General¶

• Improved error handling and logging within the AiVerificationHttpClient.

General¶

• Enhanced VerifiedTemplate to better manage child verification states.

General¶

• Fixed an issue where the role was not being propagated correctly to the login endpoint.

• Fixed an issue where ZIP files created in Windows did not preserve proper Unix permissions.

PowerBI¶

• Added support for dynamic or custom concatenation for greater flexibility in data transformations.

SSIS¶

• Implemented the core infrastructure for recursive conversion of SSIS containers (e.g., For Loop, Foreach Loop), enabling the processing of more complex structures.

SSIS¶

• Completed the implementation of inlined conversion for containers to better handle control flows.

Teradata¶

• Reordered UDFs and updated the default time format (HH:MI:SS.FF6) to improve conversion compatibility.

dbt¶

• Removed angled brackets (<>) from generated YML configuration files to prevent potential syntax errors.

• Removed unnecessary tags from models generated during ETL conversions to produce cleaner code.

• Simplified the names of generated models in ETL conversions to enhance project readability.

PostgreSQL¶

• Resolved an error in the RAISE_MESSAGE_UDF when it was called with only two parameters.

General¶

• Updated SQLite storage filename to include file extension for better file management.

• Corrected an issue in the TRANSFORM_SP_EXECUTE_SQL_STRING_UDF helper where datetime values were formatted incorrectly in dynamic SQL.

• Applied internal fixes related to Nuget package management.

• Corrected an incorrect enumeration in an internal resource file (IssueResources.json).

General¶

• Added support for IDENTITY in CTAS statements.

• Enhanced telemetry settings in data migration configuration for improved metrics collection control.

Tableau¶

• Added initial infrastructure for converting Tableau projects.

ETL & SSIS¶

• Implemented new output structure for ETL conversions, grouped by filename.

• Added support for ISNULL function conversion and variables in “Derived Column” expressions.

• Enhanced SSIS assessment report and task generation using original package names.

DB2¶

• Added support for DECLARE TABLE statement transformation.

BigQuery¶

• Added support for REGEXP_CONTAINS function.

dbt¶

• Refactored dbt project generator to unify variable conversion logic.

PowerBI¶

• Fixed CommandTimeout parameter and schema uppercase conversion issues.

SSIS¶

• Fixed critical bug with plus operator (+) on numeric operands.

General¶

• Corrected conversion rate calculation.

• Enhanced DROP TABLE handling and COALESCE type resolution.

• Removed conversion of On Commit Preserve Rows node for Teradata.

PuPr AI Verification¶

• Added new AI Verification step for SQL Server migrations.

SQL Server¶

• [Preview Feature] Support for UDF translation to Snowflake Scripting UDFs

• Support for ERROR_NUMBER to SQLCODE.

• Support for COL_LENGTH built-in function.

Teradata¶

• Support for the TD_MONTH_BEGIN, TD_WEEK_BEGIN, and TD_WEEK_END built-in functions.

• Support for hex literals in the OREPLACE built-in function.

Oracle¶

• Support ASCIISTR built-in function.

• Support for MAX DENSE_RANK FIRST and MIN DENSE_RANK LAST clauses.

SSIS¶

• Added SSIS Microsoft.Merge transformation

• Enhanced SSIS variable handling transformation

Oracle¶

• Improved recognition of correlated queries.

General¶

• IBM DB2 SQL Support
  SnowConvert AI 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.

• Added new columns to Top Level Code Unit report: Code Unit Database, Code Unit Schema and Code Unit Name

PostgreSQL & Based Languages¶

• Support for Bitwise Functions

General¶

• Modified SSC-EWI-0040 to specify the error node.

Teradata¶

• Removed .SET FORMAT from BTEQ transformation

• Fixed several BTEQ parsing errors

• Added support for BTEQ .MESSAGEOUT command

• Added pending transformation for shell variables inside conditions

• Added support for BTEQ .SET FOLDLINE command

• Added transformation for .SET TITLEDASHES command

• Downgraded EWI to FDM for STATISTICS BTEQ clause

• Downgraded EWI to FDM for PERIOD BTEQ clause

Oracle¶

• Fix transformation for DATE type attribute

SQL Server¶

• Improved the handling of procedures containing SELECT INTO statements that return a query.

• Transform @@DateFirst to GET_WEEK_START

• Numeric format function support

• Convert function support

• Datename function support

• Removed the symbol @ in the conversion that uses XML queries.

• Print statement support

• Formats for datetime support.

• Improved the update statement by removing the table name from the clause when it appears in the target table.

• Error functions translation support.

General¶

• Added a new report, SQLFunctionsUsage.csv, that summarizes the invocations of built-in and user-defined functions grouped by their migration status. This report allows users to get details about function usages, whether they were transformed to Snowflake with no problem, or whether they require an additional post-conversion action.

Teradata¶

• Added transformation for the period CONTAINS clause

Oracle¶

• Fixed the GENERATED ALWAYS AS expr column option not being transformed

• Fixed dynamic SQL code strings not having their literal values properly escaped in the output

SQL Server¶

• Fixed the DATETIME2 datatype not transformed correctly when precision is specified

• Fixed object names without brackets not being renamed when using the renamed feature

• Promoted SSC-FDM-TS0015 to EWI SSC-EWI-TS0015 to fix objects with unsupported datatypes incorrectly marked as successfuly transformed

• Fixed some virtual columns transformed to datatype VARIANT instead of the right datatype for their expression

• Implemented transformation for the STRING_SPLIT function, previously being left as is in the output code

• Fixed CREATE FUNCTION bodies not generated when a SELECT statement was found in the ELSE clause of an IF statement

• Fixed identifiers containing the @ character producing parsing errors

• Fixed the DATE_PART function incorrect transformation when the weekday part is specified

• Fixed the empty statements generated by parsing error recovery causing a pending functional equivalence error to be reported

• Fixed the DATENAME function transformation not generating the necessary UDF definitions in the UDF Helpers folder

• Fixed the TRY_CAST/TRY_CONVERT functions not being transformed in some cases

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.

Fixed¶

• Some functions were incorrectly marked as a pending functional.

Fixed¶

• Renaming feature now contemplates function with parameters.

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

Fixed¶

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

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

Fixed¶

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

Fixed¶

• Code missing when converting a function with CONNECT BY.

Fixed¶

• Flag TeraModeForStirngComparison is set to true as default.

Fixed¶

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

Fixed¶

• Code missing when converting a function with CONNECT BY.

Fixed¶

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

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

Fixed¶

• Issue with WITH DISTRIBUTION and CLUSTERED in table creation.

Fixed¶

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

Fixed¶

• Conversion of stored procedures inside macros is now supported.

• StringSimilarity Teradata Function is now converted successfully

Fixed¶

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

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

Fixed¶

• Empty Create Statement

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

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.

Fixed¶

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

Fixed¶

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

Fixed¶

• Cast to CHAR/CHARACTER causing parsing error

Fixed¶

• Empty STAT EWI when there is an extra ‘;’.

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

Fixed¶

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

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

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.

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.

SQLServer¶

• Fixed EXECUTE AS statement wrongly transformed to EXECUTE IMMEDIATE.

• Fixed temporary table generated erroneously.

• Improve parsing of WITH xmlnamespaces statement.

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.

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.

SQLServer¶

• Added translation of SET ANSI_NULLS.

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

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.

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.

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.