SnowConvert AI - Recent Release Notes¶

RedShift¶

• Added support for the CURRENT_SETTING timezone.

Spark SQL¶

• Added support for INSERT BY NAME and removed the TABLE keyword and partition clause.

PowerBI¶

• Supported dynamic parameterization in connectors with embedded queries in WHERE clauses.

RedShift¶

• Added support for HLL functions.

• Added support for JSON functions.

• Added support for OBJECT_TRANSFORM.

SSIS¶

• Added conversion support for SSIS Microsoft.ExpressionTask.

• Modified the condition used to determine if an SSIS package is reusable.

Teradata¶

• Added support for named arguments in the EXECUTE (Macro Form) statement.

• Fixed an issue where scripts were not being migrated to Snowscript.

• The Continue Handler is now available for Scripts.

PostgreSQL¶

• Fixed an issue where procedures did not have the EXECUTE AS CALLER clause generated by default when the SECURITY clause was absent in the input.

RedShift¶

• Fixed an issue where non-ASCII characters in columns were not quoted during data migration.

SQL Server¶

• Fixed an issue where default GETDATE column constraints applied an unnecessary double cast in the column definition.

General¶

• Added support for alert preview notifications.

• Improved Claude model validation to inform users about required access.

SSIS¶

• Implemented SSIS to Snowflake string literal escape sequence conversion.

Teradata¶

• Updated scripts transformation to utilize a continue handler.

General¶

• Cleaned up package.json for customer distribution.

BigQuery¶

• Fixed an aggregation issue that occurred when column aliases had the same name as table columns.

Oracle¶

• Fixed NOT NULL constraint behavior with INLINE, CHECK, and PK constraints.

SSIS¶

• Fixed an issue where comment tags were not displayed in converted reusable packages.

General¶

• Updated database dependencies and resolved dependencies vulnerabilities.

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¶

• 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.

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.

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.

• 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.

• 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¶

• 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

Adicionado¶

• Foram adicionadas as configurações «ANSI/TERA Session Mode» e «Use COLLATE for Case Specification»:

  • Modo ANSI com COLLATE.

  • Modo ANSI sem COLLATE.

  • Modo TERA com COLLATE.

  • Modo TERA sem COLLATE.

• Suporte à análise da opção de coluna GENERATED TIMECOLUMN.

• Suporte à análise de função TD_NORMALIZE_MEET.\

Corrigido¶

• Correção de inconsistências nos nomes de colunas quando se trata de palavras-chave reservadas do Snowflake.

• Erros de análise na cláusula PARTITION BY RANGE_N.

• Suporte aprimorado para a expressão COALESCE.

Corrigido¶

• Algumas funções foram marcadas incorretamente como funcionais pendentes.

Corrigido¶

• O recurso de renomeação agora contempla funções com parâmetros.

• A instrução UPDATE com a sintaxe ELSE INSERT não foi convertida corretamente.

Corrigido¶

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

• Os nomes de exibições e colunas dos objetos sys agora são emparelhados com INFORMATION_SCHEMA.

Corrigido¶

• O tipo de dados BIT com valor DEFAULT não é convertido em verdadeiro ou falso, mas em 1 ou 0.

Corrigido¶

• Código ausente ao converter uma função com CONNECT BY.

Corrigido¶

• O sinalizador TeraModeForStirngComparison é definido como true por padrão.

Corrigido¶

• As colunas com valor padrão agora são convertidas corretamente com sua respectiva conversão de tipo de dados.

Corrigido¶

• Código ausente ao converter uma função com CONNECT BY.

Corrigido¶

• Inconsistências na comparação de cadeias de caracteres no modo Tera e no modo ANSI.

• O alias de coluna complexo com sintaxe “”n não está sendo reconhecido pelo SnowConvert.

Corrigido¶

• Problema com WITH DISTRIBUTION e CLUSTERED na criação de tabelas.

Corrigido¶

• Problema que causava falha na conversão de SP ao usar .rownum em uma instrução FOR.

Corrigido¶

• Agora há suporte para a conversão de procedimentos armazenados dentro de macros.

• A função Teradata StringSimilarity foi convertida com sucesso

Corrigido¶

• DATEDIFF_UDF agora retorna a diferença de data com carimbo de data/hora como parâmetro com decimais (diferença de parte de tempo).

Corrigido¶

• Crie um procedimento armazenado para cumprir o mesmo fluxo do Teradata (StoredProcedure dentro de uma macro)

• Use um UDF Helper para emular a funcionalidade fornecida para uma coluna VALIDTIME no Teradata

Corrigido¶

• Instrução de criação vazia

• Retorna a diferença de data com o carimbo de data/hora como parâmetro com decimais (diferença de parte do tempo).

Corrigido¶

• UDF chamado «PERIOD_TO_TIME_UDF» agora é incluído como parte da saída do código se for usado no código convertido.

• UDF chamado «DATE_TO_PERIOD_UDF» agora é incluído como parte da saída do código se for usado no código convertido.

Corrigido¶

• A cláusula CLUSTERED não está mais no código de saída.

Corrigido¶

• A cláusula PARTITION em consultas agora é identificada como EWI em vez de FDM.

Corrigido¶

• Conversão CHAR/CHARACTER causando erro de análise

Corrigido¶

• Esvazie STAT EWI quando houver um “;” extra.

• A instrução Continue não está mais marcada como EWI.

Corrigido¶

• DATE_TO_RR_FORMAT_UDF agora é incluído na saída se houver uma referência a ele no código-fonte de entrada.

Teradata¶

Adicionado

• Nova configuração de conversão para a transformação de comparação de cadeias de caracteres TERA MODE

Corrigido

• Bloco anônimo de código convertido em um procedimento armazenado.

• PRIMARY TIME INDEX não está sendo analisado.

SQL Server¶

Corrigido

• As estatísticas vazias não devem ser classificadas como funcionais pendentes

• O relatório SQL tem um texto referente à Teradata

Oracle¶

Adicionado

• Conversão de função Oracle em funções (instrução única)

Corrigido

• DATE_TO_RR_FORMAT_UDF é adicionado na conversão da exibição, mas não faz parte da saída SC

Teradata¶

• Adicionada conversão para a função EXTRACT.

• Corrigida a conversão no procedimento quando houver a presença de IMMUTABLE/VOLATILE.

• Conversão aprimorada de EXTRACT_TIMESTAMP_DIFFERENCE_UDF para suportar o registro de data e hora como parâmetro.

SQL Server¶

• Melhoria no tratamento de erros ao converter colunas com nomes longos.

Oracle¶

• Adicionada conversão para a função STANDARD_HASH.

• O analisador foi aprimorado para poder ler DBMS_DATAPUMP.detach.

Teradata¶

• Adicionada conversão para PREPARE STATEMENT, ACTIVITY_COUNT, DAY_OF_MONTH, DAY_OF_WEEK, WEEK_OF_CALENDAR, MONTH_OF_CALENDAR.

• Adicionada conversão para CREATE SCHEMA.

• Corrigido literal INTERVAL não convertido em operações de subtração.

• Capacidade aprimorada do analisador para ler LATEST como um nome de coluna.

Oracle¶

• Conversão aprimorada dos tipos de dados de parâmetros PL/SQL: VARCHAR e INTEGER.

• Correção de comentários duplicados nas instruções de procedimentos em PL/SQL.

SQLServer¶

• Corrigida a instrução EXECUTE AS transformada erroneamente em EXECUTE IMMEDIATE.

• Correção da tabela temporária gerada erroneamente.

• Melhorada a análise da instrução WITH xmlnamespaces.

Oracle¶

• Corrigida a conversão de colunas com espaços em branco em CREATE VIEW.

• Descrição aprimorada de SSC-EWI-OR0042.

• Melhoria na análise da cláusula ACCESSIBLE BY e da opção SQL_MACRO de CREATE FUNCTION.

• Melhoria na análise da instrução DECLARE.

SQLServer¶

• Corrigida a conversão de BEGIN...END mostrando a equivalência funcional pendente.

• Adicionada conversão para a cláusula FOR XML PATH.

Teradata¶

• Foi adicionado EWI 0073 a uma instrução PREPARE.

• Adicionado ORREPLACE a CREATETABLE

Oracle¶

• Adição de conversão para a propriedade REFRESH_MODE da exibição materializada.

• Aprimoramento do recurso de análise para ler a cláusula MODEL e para ler as rotas alternativas CREATE VIEW.

SQLServer¶

• Adicionada a conversão de SET ANSI_NULLS.

• Foi adicionada a conversão de INSERT que contém um padrão FROM Subquery + MERGE INTO.

Oracle¶

• Aprimoramento do recurso de análise para ler as funções internas JSON_OBJECT e JSON_ARRAYAGG.

SQLServer¶

• Melhoria do conteúdo do relatório Missing Object References.

• Maior robustez durante a fase de análise semântica e a fase de conversão.

Teradata¶

• Aprimoramento da conversão relacionada ao tratamento de datas.

• Aprimoramento da capacidade de análise para ler códigos que contêm comentários em blocos.

• Aprimoramento do recurso de análise para ler a opção de coluna NOT NULL antes da instrução do tipo de dados em uma tabela.

• Melhoria da funcionalidade de TIMESTAMP_DIFFERENCE_UDF e EXTRACT_TIMESTAMP_DIFFERENCE_UDF.

SQL Server¶

• Conversão aprimorada para a restrição ALTER TABLE CHECK.

Teradata¶

• Adicionada conversão para CONTINUE HANDLER.

• Foi adicionado um novo recurso de análise para o tipo de dados BYTE.

• Melhoria nas conversões de variáveis de vinculação.

Oracle¶

• Foi adicionado e aprimorado o recurso de análise para ler a instrução EXPLAIN PLAN, U-Literals e CTAS.

• Melhoria da conversão do CURSOR quando for necessário definir um cursor com object_construct.

• Melhoria na conversão dos parâmetros do procedimento, evitando erros de implementação.

SQLServer¶

• Adicionada conversão para a função DB_ID.

• Foi adicionada uma conversão básica para CREATE SCHEMA.

• Foi adicionado um FDM para CREATE INDEX.

• Melhoria da conversão de ALTER TABLE.