SnowConvert AI - Recent Release Notes¶

RedShift¶

• Added support for RedShift function extraction.

SSIS¶

• Added support for converting sp_stop_job to ALTER TASK ... SUSPEND for SQL Server Agent Job orchestration.

• Added an orchestration file generator for SQL Server Agent Job conversion.

PowerBI¶

• Added QUOTED_IDENTIFIERS_IGNORE_CASE validation for column renaming support in Power BI conversions.

General¶

• Added a CodeSyncService and IssuesService for synchronizing issue metadata (Error Warning Information, Functional Difference Messages, Out of Scope, Performance Review) in the code unit registry when converted files are modified.

• Added connection timeout support for Snowflake credentials with authentication-specific defaults.

General¶

• Added a terminal link and icon to the SnowConvert AI home page for quick access to the command-line interface.

• Updated AgentJobOptions to support custom database usage and extra file dependencies.

• AI Verification files are now persisted in the project directory instead of temporary folders.

• Improved error handling for source connection resolution.

General¶

• Fixed an issue where the application did not handle .NET backend process crashes gracefully.

General¶

• Added a SessionManagerService for session lifecycle management.

• Moved the license file activation from the Login page to the Help menu.

General¶

• Implemented mode-aware documentation links in update notification banners.

General¶

• Fixed an issue where missing C# dependencies caused build errors.

• Fixed a crash on the progress page when step titles were unmapped, by filtering out steps without display strings.

• Fixed slow loading for AI Verification jobs.

General¶

• Implemented state management for code deployment.

• Added a Testing Orchestration engine with CSnakes Python interop.

• Implemented file size validation for AI processing.

• Added T-SQL to Snowflake TDD workflow skills for AI-assisted translation development.

Hive¶

• Added support for the Hive InStr function.

• Added support for the Hive COLLECT_SET function.

Netezza, SQL Server, Sybase, Teradata¶

• Added a disable-use-database-generation flag for schemas.

PostgreSQL¶

• Added PostgreSQL RETURN QUERY transformation support.

• Added preprocess and partial transformation support for Python functions in PostgreSQL.

RedShift¶

• Added support for transforming cursor out parameters in RedShift.

SSIS¶

• Added multi-target column unpivot translation support for SSIS.

• Added Microsoft.Pivot transformation support for dbt translation.

• Added Early Warning Indicators (EWI) for unreviewed SSIS expression functions.

• Introduced Agent Job 2.1 with base replacer and EWI/FDM codes for SSIS.

General¶

• Enhanced error handling in AI verification results by adding lastError to the job state.

• Enhanced the AI Verification Orchestrator to handle transient PENDING statuses.

• Enhanced AI verification job status handling by adding a 'FAILED' state and improving error logging.

PowerBI¶

• Removed the renaming of calculated columns in Power BI conversions.

• Removed table aliases when generating column renames for Power BI.

General¶

• Fixed a bug related to Extract Code and Code Unit Registry.

RedShift¶

• Fixed an issue with data migration navigation.

SSIS¶

• Fixed FlatFileSource naming to use the component path for unique identifiers.

Hive¶

• Added support for the Hive regexp_extract built-in function.

• Added a replacer for the Hive ISNULL function, incorporating validation best practices.

SSIS¶

• Implemented conversion for SSIS Excel Source components to Snowflake dbt.

General¶

• Added an option to disable the generation of USE DATABASE statements.

SQL Server¶

• Optimized Transact-SQL conversions by using the native parse_json() function instead of a custom UDF helper.

SSIS¶

• Added sanitization of identifiers for the flat file source translator.

• Improved the SSIS TDD skill based on insights from Microsoft Pivot migration retrospectives.

General¶

• Added test generation capabilities guard and TST0003 error handling.

• Renamed the Data Validation CSnakes bridge to _dvf_csnakes_bridge.py.

Power BI¶

• Fixed an issue where query values were lost when migrating multiple Power BI Template (.pbit) files simultaneously.

Hive¶

• Added support for converting the FROM_UTC_TIMESTAMP function from Hive to Snowflake.

SSIS¶

• Added support for SSIS Aggregate transformation in dbt translation.

• Added an ssis-tdd skill to support the SSIS-to-Snowflake Test-Driven Development (TDD) workflow.

• Added support for translating Microsoft.Sort transformations from SSIS to Snowflake.

Power BI¶

• Added an optional ROLE parameter for Power BI conversions.

General¶

• Enhanced AI Verification by adding support for Key Pair Authentication.

• Added registry generation to the Extract command.

• Integrated with the scai test seed test generation library.

• Added CUBE to the list of supported ANSI built-in functions.

General¶

• Enhanced AI conversion logs with improved detail and readability.

• Improved the display of friendly error messages and server-side error details on the AI code conversion error page.

SSIS¶

• Fixed dot-delimited table names being incorrectly split during dbt model generation for SSIS conversions.

• Fixed the ExcelSource conversion to the previous Snowflake dbt TDD implementation.

General¶

• Fixed an issue with AI Verification where double-nested source directories were not resolved correctly.

• Fixed an issue with AI Verification two-sided mode serialization.

• Fixed an issue with Data Validation and the minimum Python environment version installation.

Hive¶

• Added support for converting the FROM_UTC_TIMESTAMP function from Hive to Snowflake.

SSIS¶

• Added support for SSIS Aggregate transformation in dbt translation.

• Added an SSIS-TDD skill to support the SSIS-to-Snowflake Test-Driven Development workflow.

• Added support for Microsoft.Sort operations in SSIS-to-Snowflake conversions.

PowerBI¶

• Added an optional ROLE parameter for Power BI conversions.

General¶

• Introduced an -o option for ETL AI verification.

• Implemented Snowflake credential override options and improved authentication error messages.

• Added CUBE to the list of supported ANSI built-in functions.

General¶

• Enhanced internal data transfer objects, input building, and progress handling.

• Updated the version retrieval script to save results directly to a file.

• Unified AI Verification with the Standard Job Orchestrator for streamlined operations.

• Refactored job orchestration to support asynchronous job initiation.

• Updated the 'limit reached' message for improved clarity.

General¶

• Added Snow-to-Snow support in Data Validation.

• Added AI verification support for SEQUENCE object types.

• Added support for a new AI code conversion contract.

SSIS¶

• Extended IsString functionality to detect strings through parentheses, function calls, casts, and concatenation (+) expressions.

Informatica¶

• Improved the conversion of the INSTR built-in function in expressions.

General¶

• Implemented code unit deduplication in the Job Status Mapper to prevent duplicate entries.

• Added a link to the assessment report and improved the ordering of cards on the project page.

• Enabled offline mode for license installation and improved connection error logging.

• Improved error messages for Snowflake authentication failures and refactored connection resolution for commands.

• Introduced AiVerificationTestBase to support language as a parameter in AI verification tests.

• Updated the AI initial prompt message and corrected a UI icon.

• Enhanced AI verification job execution to prioritize the source_Processed directory when available.

• Added InvalidInputError handling for AI verification inputs.

SSIS¶

• Fixed inconsistent Start/End block tagging in stored procedure output.

General¶

• Fixed an issue where SnowConvert AI displayed unsupported objects as pending.

SQL Server¶

• Added support for INSERT INTO EXECUTE in procedures.

• Added support for CONCAT_NULL_YIELDS_NULL, NUMERIC_ROUNDABORT, and ARITHABORT SET options.

SSIS¶

• Added OLE DB Command (DELETE/UPDATE) support for SSIS to dbt translation.

• Added conversion of completion precedence constraints.

Power BI¶

• Added support for repointing connections identified as pending changes.

General¶

• Added Terms and Conditions acceptance functionality.

SSIS¶

• Improved the placement of SSIS task comment tags for better readability.

General¶

• Enhanced the project header to display source dialect names alongside project names.

• Improved error handling for array-type errors in conversion results.

SQL Server¶

• Fixed resultset handling for set operators.

SSIS¶

• Fixed false column collision on Lookup No Match output paths.

• Fixed start tags not being added to unsupported control flow tasks.

General¶

• Fixed deployment error messages not being cleared after a successful redeployment.

• Fixed an issue where empty capabilities caused unexpected behavior.

Hive¶

• Added support for Hive Date Format.

General¶

• Added new outcomes for source and converted dependency failures in AI Verification.

• Added a SQL platform selector.

• Implemented logic to split logs by execution and to clean up logs older than 30 days.

General¶

• Changed connection testing to use session state instead of querying data.

• Updated conversion status messages and adjusted icon usage in status templates for better clarity and consistency.

• Updated the deployment_order column to allow null values and enhanced parsing logic in the CodeConversionService.

• Changed conversion status and type to object type.

• Enhanced script extraction descriptions and integrated source dialect information in the CodeConversionService CodeLoadPage.

• Added quick access to the connections file from the Login page.

• Ensured all files are copied in AI output when AI flags are enabled.

BigQuery¶

• Enabled BigQuery dialect support for AI Verification.

PostgreSQL¶

• Enabled PostgreSQL dialect support for AI Verification.

Redshift¶

• Added support for the STRTOL function.

• Added support for assigning query results to variables within stored procedures.

SQL Server¶

• Added support for the HASHBYTES function.

General¶

• Added accept command for AI-Convert.

• Added object selector support in Code Deployment.

• Added source and target mapping information in the ETL.Elements report.

• Added support for the FROM_UNIXTIME built-in function.

SQL Server¶

• Improved code formatting.

• Excluded aliases from the Object References report.

General¶

• Added 'Learn More' links to footers and introduced body-small-italic text variant.

• Migrated from InternalError to the ScError interface for enhanced error handling.

• Added safeguard to prevent accidental application closure during active conversions.

• Enhanced error handling for code conversions and added tooltips to results tables in Data Migration and Validation.

• Removed unused reject change functionality.

• Refactored connection resolution to separate credential validation from connectivity testing.

• Updated DataMigrator component and refactored Snowflake credential handling.

PostgreSQL¶

• Fixed the ordering of generated function options to prevent deployment errors in Snowflake.

General¶

• Fixed an issue preventing the reporting issue modal from displaying correctly.

• Fixed HOST_NAME() function conversion to CURRENT_IP_ADDRESS() when using FDM.

General¶

• Added a legacy view for code process results.

• Added support for using a .yaml configuration file in the Data Validation command.

• Added direct access to OpenLogs from the application menu.

• Added support for an object selector in Data Validation.

General¶

• Implemented a mechanism to read from connections.toml and fall back to config.toml when retrieving the default connection.

General¶

• Fixed an issue where AI Verification was missing .sql content.

• Fixed an issue where the application did not navigate to results after partially successful migration and validation, and resolved name overflow in progress cards.

RedShift¶

• Added support for RedShift in Data Validation.

General¶

• Added a Sign Out option to the application menu.

• Implemented an offline mode for project commands.

• Added support for the Unix_TimeStamp built-in function.

RedShift¶

• Improved error propagation within the Data Validation feature.

General¶

• Added a loading fallback mechanism for the Login page.

• Added dynamic model validation to AI Verification processes.

• Refactored the AI Verification Service to manage job options on a per-project basis.

• Set the connection project default and improved AI Verification commands.

• Improved handling of ConvertedObjectFixAttemptFailed status in two-sided conversion runs.

• Added migration project context, loading it from a project-relative path.

Teradata¶

• Fixed the ordering of column options when column-level collation is generated for Teradata conversions.

General¶

• Fixed path comparison logic to correctly handle null or whitespace input in the ValidateInputPath method.

• Resolved an issue causing blinking when opening a project.

SSIS¶

• Added support for converting Microsoft.BulkInsertTask.

• Implemented conversion support for Execute Package Variable Binding.

• Added support for converting INSERT...OUTPUT INSERTED statements to INSERT + SELECT INTO.

PostgreSQL¶

• Updated the transformation of << and >> bitwise operators to correctly handle integer type differences when converting from PostgreSQL to Snowflake.

General¶

• Updated Snowflake authentication to be handled directly through the IConnectionResolver, utilizing the provided connection when available.

• Implemented data validation improvements.

SSIS¶

• Resolved a styling issue affecting cards in the ETL SSIS Report.

• Fixed an issue where the "Check dependencies" button in the ETL SSIS Report was not functioning.

General¶

• Corrected the architecture name used for macOS Intel installers.

• Removed the access code requirement and implemented a direct redirect to the login page.

• Added source system text and corrected color display.

General¶

• Cached the VS Code path to improve performance.

• Updated connection redirection to fetch the last used credentials.

Oracle¶

• Added support for the NULLIF function to trim transformations for Oracle.

RedShift¶

• Fixed the RedShift connection handling for the default port and removed duplicated authentication method input.

SQL Server¶

• Fixed an issue where JSON_UDF.sql was not being deployed for SQL Server.

• Fixed integer divisions to correctly use truncation for SQL Server.

General¶

• Implemented renaming in testing mode and on the verify button.

• Changed the name of "AI Verification" to "AI Code Conversion".

• Created data models for selector commands and refactored the TopLevelCodeUnits reader.

• Added useUserMetadata to set user metadata for telemetry.

• Replaced temporary credentials with active credentials across the application.

• Added the useCredentialStorage hook for managing credential IDs in local storage.

• Added a host URL input field to the Snowflake Connection Form.

• Added an AI Verification disclaimer.

• Added pre-extraction checks for the Code Extraction command, including a source connection test.

• Added collation support to code extraction.

• Added a Technical Discovery section.

Redshift¶

• Changed the WITH NO SCHEMA BINDING transformation to always remove it for Redshift conversions.

SQL Server¶

• Fixed an issue with SELECT statements containing a variable in the TOP clause for SQL Server conversions.

Teradata¶

• Removed the NEXT keyword in fetch next statements for Teradata conversions.

General¶

• Fixed an issue where procedures and views were not marked as verified by the user.

• Fixed an issue in two-sided validation.

• Fixed path validation when autocompleting.

• Implemented UI fixes for the "Use the extraction script" section.

• Fixed an issue with temporary tables having an incorrect schema.

Hive/Spark/Databricks¶

• Added DATE_SUB function replacers.

PostgreSQL¶

• Added an arrange option for routines with quoted definitions.

• Added preprocessing for single-quoted procedure bodies.

Teradata¶

• Added support for .IMPORT and .SET commands in Mload.

SSIS¶

• Added an ETL SSIS Report.

• Enhanced variables conversion with improvements and refactoring.

PowerBI¶

• Added support for column renaming in embedded SQL cases.

General¶

• Implemented project input validations.

• Added user metadata to telemetry upon login.

• Added list, cancel, and status commands for AI Verification.

• Added an initial Login Page with enhanced licensing features.

• Added support for AI Verification contracts.

• Added transformation of SQL code within dbt_project.yml variables.

SQL Server¶

• Improved the transformation of the ROW keyword as a reserved keyword.

• Removed unnecessary commas from Transact-SQL transformation output.

Teradata¶

• Updated the collation conversion setting to align with the tool's new default behavior.

• Updated current collation support to ensure compatibility with Iceberg Tables transformations.

• Removed CREATE STAGE and PUT commands from the EXECUTE IMMEDIATE block in Mload transformations.

General¶

• Improved AI Verification status reporting.

• Improved consistency of capitalization in Settings tabs.

• Consolidated the definition of source languages that support database connections for an improved end-to-end flow.

• Updated the code extraction command to enhance object type handling and improve progress reporting.

• Refactored the Translation API and implemented logic for Mapplet CTE generation.

• Refactored SQL transformation for variables.

• Added a Mapplet CTE Builder Module.

SQL Server¶

• Fixed an issue with the coalesce function for integer types when an empty string was present.

General¶

• Corrected an issue where AI verification results were not showing two-sided comparisons.

• Removed Etl instrumentation argument.

• Added null validation to the RAISERROR helper parameters.

General¶

• SQL Server extraction process now adds 'GO' statements after USE database commands in object definition files to allow files to be executable.

• Metadata extraction now intelligently focuses on extracting only supported object types for each specific platform.

• Improved conversion settings and disabled action buttons when a conversion status is pending (e.g., during AI verification).

• Added a ConnectionInfoBanner component to clearly display saved connection information.

• Refactored credential management by removing secret handling methods and simplifying connection processes.

• Introduced a database dropdown in data migration and validation screens and removed unnecessary required fields in connection configurations.

• Updated an internal dependency from 'balto' to 'stellar'.

• Enhanced internal utilities for managing test results and progress.

General¶

• The Missing Object Report has been merged into Object References, streamlining reporting. This unifies both valid and missing object references in a single report.

General¶

• Implemented a mechanism to parse and modify .toml files for credentials for Snowflake and various source languages.

General¶

• Implemented initial code unit state management using JSON files.

• Added a new JobStorageService.

• Implemented AI verification server and interfaces.

• Added support for identity columns in table definition queries.

• Added required credentials configuration for the Data Migration Connection Page and updated the Data Validation Connection Page to include KeyPair as a supported authentication method.

• Migrated AI Verification to the new jobs infrastructure and services.

• Added models for the AI Verification job.

• Defined reader and writer components for TOML files.

General¶

• Updated the VersionInfoProvider to strip branch and commit hash from the version string.

• Added a missing singletons registry for dependency injection.

• Made the reportFilePath optional in CodeUnitConversionProgress.

• Moved the SpcsManager and its dependencies to the Databases project for better organization.

• Implemented an AI verification orchestrator.

• Refactored credential management methods to utilize CreateOrEditCredentials.

• Updated conversion status in other features when verified by a user.

• Removed AI Verification v1.

• Enhanced password input fields to prevent overflowing.

• Refactored AI Verification to use CredentialsId instead of ConnectionString.

• Improvements in the deploy command.

• Updated application version retrieval to use semantic versioning.

Teradata¶

• Fixed parenthesis issues that caused incorrect PARTITION BY generation for Iceberg table transformations in Teradata.

General¶

• Fixed SSO URL handling in Snowflake credentials configuration.

• Addressed minor issues related to AI verification.

• Fixed relative paths in AI verification job execution and application state management.

IBM DB2¶

• Implemented DECFLOAT transformation.

Oracle¶

• Added support for transforming NUMBER to DECFLOAT using the Data Type Mappings feature.

• Added a new report TypeMappings.csv that displays the data types that were changed using the Data Type Mappings feature.

PowerBI¶

• Added support for the Transact connector pattern for queries and multiple properties in the property list for PowerBI.

Teradata¶

• Added a new conversion setting Tables Translation which allows transforming all tables in the source code to a specific table type supported by Snowflake.

• Enabled conversion of tables to Snowflake-managed Iceberg tables.

SSIS¶

• Added support for full cache in SSIS lookup transformations.

General¶

• Added temporary credentials retrieval for AI Verification jobs.

• Added summary cards for selection and result pages.

• Implemented full support for the Git Service.

• Added 'verified by user' checkboxes and bulk actions to the selection and results pages.

• Added a dependency tag for AI Verification.

• Implemented the generation of a SqlObjects Report.

RedShift¶

• Optimized RedShift transformations to only add escape characters when necessary in LIKE conditions.

SSIS¶

• Improved Microsoft.DerivedColumn migrations for SSIS.

General¶

• Added the number of copied files to relevant outputs.

• Changed some buttons to the footer for improved UI consistency.

Teradata¶

• Fixed transformation of bash variables substitution in scripts.

RedShift¶

• Added support for the MURMUR3_32_HASH function.

• Replaced Redshift epoch and interval patterns with Snowflake TO_TIMESTAMP.

SSIS¶

• Added support for converting Microsoft SendMailTask to Snowflake SYSTEM.

• Implemented SSIS event handler translation for OnPreExecute and OnPostExecute.

SQL Server¶

• Enhanced transformation for the Round function with three arguments.

Informatica¶

• Updated InfPcIntegrationTestBase to import the real implementation of translators and other necessary components.

General¶

• Enhanced procedure name handling and improved identifier splitting logic.

• Improved object name normalization in DDL extracted code.

• Implemented a temporal variable to keep credentials in memory and retrieve the configuration file.

• Updated the TOML Credential Manager.

• Improved error suggestions.

• Added missing path validations related to ETL.

• Improved the application update mechanism.

• Implemented an exception to be thrown when calling the ToToml method for Snowflake credentials.

• Changed the log path and updated the cache path.

• Implemented a mechanism to check for updates.

• Merged the Missing Object References Report with ObjectReferences.

• Changed values in the name and description columns of the ETL.Issues report.

• Added support for Open Source and Converted models in AI Verification.

• Added a new custom JSON localizer

• Added a dialog to appear when accepting changes if multiple code units are present in the same file.

• Added a FileSystemService.

• Added an expression in the ETL issues report for SSISExpressionCannotBeConverted.

SQL Server¶

• Fixed a bug that caused the report database to be generated incorrectly.

• Fixed a bug that caused unknown Code Units to be duplicated during arrangement.

General¶

• Fixed an issue that prevented the cancellation of AI Verification jobs.

• Fixed an issue to support EAI in the AI specification file.

• Fixed an issue where the progress number was not being updated.

• Fixed the handling of application shutdowns during updates.

SQL Server¶

• Enhanced SQL Server code extraction to return schema-qualified objects.

General¶

• Enhanced Project Service and Snowflake Authentication for improved execution.

• Removed GS validation from client-side, as it is now performed on the server side.

• Implemented connection validation to block deployment, data migration, and data validation when a connection is unavailable.

• Enhanced conversion to use the source dialect from project initialization.

• Improved CodeUnitStatusMapper to accurately handle progress status in UI status determination.

• Implemented batch insert functionality for enhanced object result processing.

General¶

• Resolved an issue where conversion settings were not being saved correctly.

• Corrected data validation select tree to properly skip folders.

• Fixed content centering issues in the UI.

• Normalized object names in AI Verification responses to prevent missing status entries in the catalog.

General¶

• Resolved an issue where PowerBI was not correctly displayed in the list of supported languages.

IBM DB2¶

• Added transformation support for SELECT INTO and VALUES statement for variable assignments within User-Defined Functions (UDFs).

Oracle¶

• Added transformation support for SELECT INTO for variables assignments within User-Defined Functions (UDFs).

SQL Server¶

• Added transformation support for SELECT INTO for variables assignments within User-Defined Functions (UDFs).

SSIS¶

• Added support for SSIS Event Handlers.

General¶

• Introduced AI Verification Contract Model Codes.

• Created a base component for the Code Processing View.

• Implemented YAML reading and writing services with an enhanced info command.

• Created an execution type selector page.

General¶

• Updated GS Version to 9.50.99 to ensure compatibility with newer versions of GS.

• Expanded job storage test coverage across data validation, migration, deployment, extraction, metadata, and AI verification.

• Refactored the FilteredObjectExplorer layout and removed unnecessary container styles from the AI Verification Selection Page and Mappings Page to improve UI consistency.

• Enhanced deployment database selection.

SQL Server¶

• Resolved an error that occurred when parsing SQL Server connections with a specific port.

General¶

• Resolved an issue where mappings were not functioning correctly in code conversion.

• Corrected the process for cleaning the conversion directory before conversion.

• Fixed deployment dropdown functionality.

Teradata¶

• Added support for GOTO-LABELS in SnowScript.

Spark SQL¶

• Added support for transformation rules to handle INSERT OVERWRITE statements.

SQL Server¶

• Added support for the CREATE SEQUENCE statement.

General¶

• Added support for IBM Db2 from the UI.

• Fixed Db2 support in SourceDialect and Update Conversion settings window.

• Added support for tables with large numbers of rows (> 2.5B) in data migrator.

SQL Server¶

• Added support for the CREATE SEQUENCE statement.

General¶

• Added a notification to inform users about the SnowConvertAI 2.0 New UI experience.

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

新增¶

• 添加了“ANSI/TERA 会话模式”和“使用 COLLATE 获取案例规格”设置：

  • 带有 COLLATE 的 ANSI 模式。

  • 没有 COLLATE 的 ANSI 模式。

  • 带有 COLLATE 的 TERA 模式。

  • 没有 COLLATE 的 TERA 模式。

• 支持解析 GENERATED TIMECOLUMN 列选项。

• 支持解析 TD_NORMALIZE_MEET 函数。\

已修复¶

• 修复了涉及 Snowflake 保留关键字时列名称不一致的问题。

• PARTITION BY RANGE_N 子句中的解析错误。

• 改进了对 COALESCE 表达式的支持。

已修复¶

• 某些函数被错误地标记为待定功能。

已修复¶

• 重命名功能现在考虑带参数的函数。

• 使用 ELSE INSERT 语法的 UPDATE 语句转换不正确。

已修复¶

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

• 系统对象中的视图和列名现在与 INFORMATION_SCHEMA 配对。

已修复¶

• 具有 DEFAULT 值的 BIT 数据类型不会转换为 true 或 false，而是转换为 1 或 0。

已修复¶

• 使用 CONNECT BY 转换函数时缺少代码。

已修复¶

• 标记 TeraModeForStirngComparison 默认设置为 true。

已修复¶

• 现在，使用相应的数据类型转换可以正确转换具有默认值的列。

已修复¶

• 使用 CONNECT BY 转换函数时缺少代码。

已修复¶

• Tera 模式和 ANSI 模式下的字符串比较不一致。

• SnowConvert 无法识别语法为 ''n 的复杂列别名。

已修复¶

• 创建表时存在 WITH DISTRIBUTION 和 CLUSTERED 的问题。

已修复¶

• 在 FOR 语句中使用 .rownum 时导致 SP 转换失败的问题。

已修复¶

• 现在支持在宏内部转换存储过程。

• StringSimilarity Teradata 函数现已成功转换

已修复¶

• DATEDIFF_UDF 现在返回以时间戳为参数的日期差，并使用小数（时间部分差）。

已修复¶

• 创建存储过程以遵循与 Teradata 中相同的流程（宏内部的 StoredProcedure）

• 使用 UDF 辅助函数模拟 Teradata 中为 VALIDTIME 列提供的功能

已修复¶

• 清空创建语句

• 返回以时间戳为参数的日期差，并使用小数（时间部分差）。

已修复¶

• 如果在转换后的代码中使用名为“PERIOD_TO_TIME_UDF”的 UDF，现在将作为代码输出的一部分包括在代码输出中。

• 如果在转换后的代码中使用名为“DATE_TO_PERIOD_UDF”的 UDF，现在将作为代码输出的一部分包括在代码输出中。

已修复¶

• CLUSTERED 子句不再出现在输出代码中。

已修复¶

• 查询中的 PARTITION 子句现在被识别为 EWI 而不是 FDM。

已修复¶

• 强制转换为 CHAR/CHARACTER 导致解析错误

已修复¶

• 如果有额外的“;”，则清空 STAT EWI。

• Continue 语句不再被标记为 EWI。

已修复¶

• 如果输入源代码中引用了 DATE_TO_RR_FORMAT_UDF，则输出中现在会包含该值。

Teradata¶

新增

• TERA MODE 字符串比较转换的新转换设置

已修复

• 匿名代码块转换为存储过程。

• 未解析 PRIMARY TIME INDEX。

SQL Server¶

已修复

• 空的统计数据不应归类为待运行

• SQL 报告有一段引用了 Teradata 的文本

Oracle¶

新增

• Oracle 函数转换为函数（单一语句）

已修复

• DATE_TO_RR_FORMAT_UDF 已添加到视图转换中，但不是 SC 输出的一部分

Teradata¶

• 添加了 EXTRACT 函数的转换。

• 修复程序中存在 IMMUTABLE/VOLATILE 时的转换问题。

• 改进了 EXTRACT_TIMESTAMP_DIFFERENCE_UDF 的转换，以支持将时间戳作为参数

SQL Server¶

• 改进了转换长命名列时的错误处理。

Oracle¶

• 添加了 STANDARD_HASH 函数的转换。

• 改进了解析器，使其能够读取 DBMS_DATAPUMP.detach。

Teradata¶

• 添加了 PREPARE STATEMENT、ACTIVITY_COUNT、DAY_OF_MONTH、DAY_OF_WEEK、WEEK_OF_CALENDAR、MONTH_OF_CALENDAR 的转换。

• 添加了 CREATE SCHEMA 的转换。

• 修复了 INTERVAL 字面量在减号运算中无法转换的问题。

• 改进了解析器将 LATEST 读取为列名的功能。

Oracle¶

• 改进了 PL/SQL 参数数据类型的转换：VARCHAR 和 INTEGER。

• 修复了 PL/SQL 过程声明中的重复注释。

SQLServer¶

• 修复了 EXECUTE AS 语句错误地转换为 EXECUTE IMMEDIATE 的问题

• 修复了错误生成的临时表。

• 改进对 WITH xmlnamespaces 语句的解析。

Oracle¶

• 修复了 CREATE VIEW 中带有空格的列的转换问题。

• 改进了 SSC-EWI-OR0042 的描述。

• 改进了 CREATE FUNCTION 中的 ACCESSIBLE BY 子句和 SQL_MACRO 选项的解析。

• 改进了 DECLARE 语句的解析。

SQLServer¶

• 修复了 BEGIN…END 的转换显示待处理的功能等效性。

• 添加了 FOR XML PATH 子句的转换。

Teradata¶

• 在 PREPARE 语句中添加了 EWI 0073。

• 在 CREATE TABLE 中添加了 OR REPLACE

Oracle¶

• 添加了物化视图的 REFRESH_MODE 属性的转换。

• 改进了读取 MODEL 子句和读取 CREATE VIEW 备用路由的解析能力。

SQLServer¶

• 添加了 SET ANSI_NULLS 的转换。

• 添加了包含 FROM Subquery + MERGE INTO 模式的 INSERT 的转换。

Oracle¶

• 改进了读取 JSON_OBJECT 和 JSON_ARRAYAGG 内置函数的解析能力。

SQLServer¶

• 改进了“缺少对象引用”报告的内容。

• 提高了语义分析阶段和转换阶段的稳健性。

Teradata¶

• 改进了与日期处理相关的转换。

• 改进了读取包含区块注释的代码的解析能力。

• 改进了在表中声明数据类型之前读取 NOT NULL 列选项的解析能力。

• 改进了 TIMESTAMP_DIFFERENCE_UDF 和 EXTRACT_TIMESTAMP_DIFFERENCE_UDF 的功能。

SQL Server¶

• 改进了 ALTER TABLE CHECK 约束的转换。

Teradata¶

• 添加了 CONTINUE HANDLER 的转换。

• 为 BYTE 数据类型添加了新的解析功能。

• 改进了绑定变量的转换。

Oracle¶

• 添加并改进了解析功能，以读取 EXPLAIN PLAN 语句、U-Literals 和 CTAS。

• 当必须使用 object_construct 定义游标时，改进 CURSOR 的转换。

• 改进了过程参数的转换，避免了部署错误。

SQLServer¶

• 添加了 DB_ID 函数的转换。

• 为 CREATE SCHEMA 添加了基本转换。

• 为 CREATE INDEX 添加了 FDM。

• 改进了 ALTER TABLE 转换。