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

Ajouté¶

• Ajout des paramètres « ANSI/TERA Session Mode » et « Use COLLATE for Case Specification » :

  • Mode ANSI avec COLLATE.

  • Mode ANSI sans COLLATE.

  • Mode TERA avec COLLATE.

  • Mode TERA sans COLLATE.

• Prise en charge de l’analyse syntaxique de l’option de colonne GENERATED TIMECOLUMN.

• Prise en charge de l’analyse syntaxique de la fonction TD_NORMALIZE_MEET

Correction¶

• Correction des incohérences dans les noms de colonnes en ce qui concerne les mots-clés réservés de Snowflake.

• Erreurs d’analyse dans la clause PARTITION BY RANGE_N.

• Amélioration de la prise en charge de l’expression COALESCE.

Correction¶

• Certaines fonctions ont été marquées à tort comme fonction en attente.

Correction¶

• La fonction de renommage prend désormais en compte les fonctions avec paramètres.

• L’instruction UPDATE avec la syntaxe ELSE INSERT n’a pas été convertie correctement.

Correction¶

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

• Les noms de vues et de colonnes des objets sys sont désormais associés à INFORMATION_SCHEMA.

Correction¶

• Le type de données BIT avec la valeur DEFAULT n’est pas converti en vrai ou faux mais en 1 ou 0.

Correction¶

• Code manquant lors de la conversion d’une fonction avec CONNECT BY.

Correction¶

• L’indicateur TeraModeForStirngComparison est défini par défaut sur true.

Correction¶

• Les colonnes ayant une valeur par défaut sont désormais converties correctement avec leur type de données respectif.

Correction¶

• Code manquant lors de la conversion d’une fonction avec CONNECT BY.

Correction¶

• Incohérences dans la comparaison de chaînes en mode Tera et en mode ANSI.

• L’alias de colonne complexe avec la syntaxe “”n n’est pas reconnu par SnowConvert.

Correction¶

• Problème avec WITH DISTRIBUTION et CLUSTERED dans la création de tables.

Correction¶

• Problème entraînant l’échec de la conversion SP lors de l’utilisation de .rownum dans une instruction FOR.

Correction¶

• La conversion des procédures stockées à l’intérieur des macros est désormais prise en charge.

• La fonction Teradata StringSimilarity est maintenant convertie correctement

Correction¶

• DATEDIFF_UDF renvoie désormais la différence de date avec l’horodatage comme paramètre avec des décimales (différence de partie temporelle).

Correction¶

• Création d’une procédure stockée pour respecter le même flux que dans Teradata (StoredProcedure à l’intérieur d’une macro)

• Utilisation d’un assistant UDF pour émuler la fonctionnalité donnée pour une colonne VALIDTIME dans Teradata

Correction¶

• Instruction de création vide

• Renvoie la différence de date avec l’horodatage en tant que paramètre avec des décimales (différence de temps).

Correction¶

• L’UDF appelée « PERIOD_TO_TIME_UDF » est désormais incluse dans la sortie du code si elle est utilisée dans le code converti.

• L’UDF appelée « DATE_TO_PERIOD_UDF » est désormais incluse dans la sortie du code si elle est utilisée dans le code converti.

Correction¶

• La clause CLUSTERED ne figure plus dans le code de sortie.

Correction¶

• La clause PARTITION dans les requêtes est désormais identifiée comme EWI au lieu de FDM.

Correction¶

• Les conversions vers CHAR/CHARACTER provoquent une erreur d’analyse

Correction¶

• STAT EWI Vide lorsqu’il y a un “;” supplémentaire.

• L’instruction Continue n’est plus marquée comme EWI.

Correction¶

• DATE_TO_RR_FORMAT_UDF est désormais inclus dans la sortie s’il y a une référence à celui-ci dans le code source d’entrée.

Teradata¶

Ajouté

• Nouveau paramètre de conversion pour la transformation de comparaison des chaînes TERA MODE

Correction

• Bloc de code anonyme converti en procédure stockée.

• PRIMARY TIME INDEX n’est pas analysé.

SQL Server¶

Correction

• Les statuts vides ne doivent pas être classés comme des fonctions en attente

• Le rapport SQL contient une référence à Teradata

Oracle¶

Ajouté

• Conversion de fonctions Oracle en fonctions (instruction unique)

Correction

• DATE_TO_RR_FORMAT_UDF est ajouté dans la conversion de la vue mais ne fait pas partie de la sortie SC

Teradata¶

• Ajout de la traduction de la fonction EXTRACT.

• Correction de la traduction dans la procédure en cas de présence de IMMUTABLE/VOLATILE.

• Amélioration de la traduction de EXTRACT_TIMESTAMP_DIFFERENCE_UDF pour prendre en charge l’horodatage en tant que paramètre.

SQL Server¶

• Amélioration de la gestion des erreurs lors de la traduction des colonnes à nom long.

Oracle¶

• Ajout de la traduction pour la fonction STANDARD_HASH.

• Amélioration de l’analyseur pour pouvoir lire DBMS_DATAPUMP.detach.

Teradata¶

• Ajout de la traduction pour PREPARE STATEMENT, ACTIVITY_COUNT, DAY_OF_MONTH, DAY_OF_WEEK, WEEK_OF_CALENDAR, MONTH_OF_CALENDAR.

• Ajout de la traduction pour CREATE SCHEMA.

• Correction du littéral INTERVAL non converti dans les opérations de minoration.

• Amélioration de la capacité de l’analyseur à lire LATEST comme nom de colonne.

Oracle¶

• Amélioration de la traduction des types de données des paramètres PL/SQL : VARCHAR et INTEGER.

• Correction des commentaires dupliqués dans les déclarations de procédures PL/SQL.

SQLServer¶

• Correction de l’instruction EXECUTE AS transformée à tort en EXECUTE IMMEDIATE.

• Correction de la table temporaire générée par erreur.

• Amélioration de l’analyse de l’instruction WITH xmlnamespaces.

Oracle¶

• Correction de la traduction des colonnes contenant des espaces dans CREATE VIEW.

• Amélioration de la description de SSC-EWI-OR0042.

• Amélioration de l’analyse de la clause ACCESSIBLE BY et de l’option SQL_MACRO de CREATE FUNCTION.

• Amélioration de l’analyse de l’instruction DECLARE.

SQLServer¶

• Correction de la traduction de BEGIN. ..END montrant l’équivalence fonctionnelle en attente.

• Ajout de la traduction de la clause FOR XML PATH.

Teradata¶

• Ajout d’une instruction EWI 0073 à PREPARE.

• Ajout de ORREPLACE à CREATETABLE

Oracle¶

• Ajout d’une traduction pour la propriété REFRESH_MODE de la vue matérialisée.

• Amélioration de la capacité d’analyse pour lire la clause MODEL et pour lire les routages alternatifs CREATE VIEW.

SQLServer¶

• Ajout de la traduction de SET ANSI_NULLS.

• Ajout de la traduction de INSERT qui contient une sous-requête FROM + un modèle MERGE INTO.

Oracle¶

• Amélioration de la capacité d’analyse syntaxique pour lire les fonctions intégrées JSON_OBJECT et JSON_ARRAYAGG.

SQLServer¶

• Amélioration du contenu du rapport Références d’objets manquantes.

• Amélioration de la robustesse lors de la phase d’analyse sémantique et de la phase de traduction.

Teradata¶

• Amélioration de la traduction relative à la gestion des dates.

• Amélioration de la capacité d’analyse syntaxique pour la lecture de codes contenant des blocs de commentaires.

• Amélioration de la capacité d’analyse pour lire l’option de colonne NOT NULL avant la déclaration du type de données dans une table.

• Amélioration de la fonctionnalité de TIMESTAMP_DIFFERENCE_UDF and EXTRACT_TIMESTAMP_DIFFERENCE_UDF.

SQL Server¶

• Amélioration de la traduction de la contrainte ALTER TABLE CHECK.

Teradata¶

• Ajout de la traduction pour CONTINUE HANDLER.

• Ajout d’une nouvelle capacité d’analyse pour le type de données BYTE.

• Amélioration des traductions des variables de liaison.

Oracle¶

• Ajout et amélioration de la capacité d’analyse syntaxique pour lire les instructions EXPLAIN PLAN, les littéraux U et CTAS.

• Amélioration de la traduction de CURSOR lorsqu’il doit définir un curseur avec l’objet_construct.

• Amélioration de la traduction des paramètres de procédure afin d’éviter les erreurs de déploiement.

SQLServer¶

• Ajout de la traduction pour la fonction DB_ID.

• Ajout d’une traduction de base pour CREATE SCHEMA.

• Ajout d’un FDM pour CREATE INDEX.

• Amélioration de la traduction de ALTER TABLE.