SnowConvert AI - Recent Release Notes¶

Informatica¶

• Added Stored Procedure Connected Normal mode translation.

PostgreSQL¶

• Added transformation support for the QUOTE_LITERAL function.

RedShift¶

• Added support for Iceberg migrations.

• Enabled Cloud Data Migration for Redshift.

• Added support for CASCADE DROP transformation.

SSIS¶

• Added conversion of UserName, PackageName, PackageID, and ExecutionInstanceGUID SSIS System Variables.

• Enabled SSIS Data Flow Simplification as a GA feature.

Teradata¶

• Enabled AI Conversion for Teradata.

• Added CREATE DATABASE translation to Snowflake.

General¶

• Added Cloud Data Validation foundation layer.

• Added CSV report writer for code extraction.

• Added extraction log writer for code extraction.

• Integrated extraction reports into the code extraction workflow.

• Added opt-in support for cloud deployment status tracking.

Informatica¶

• Added Functional Difference Messages (FDMs) to Informatica PowerCenter reusable transformations.

General¶

• Added autoplay to the carousel component.

• Improved uploaded drivers retrieval for AI Verification.

• Enabled ReadyToRun pre-compilation for improved startup performance.

• Improved AI code conversion error messages when Cortex/LLM access is denied.

• Improved two-sided AI Verification environment handling and navigation stability.

• Improved performance by using local credentials first to avoid unnecessary Snowflake connections.

BigQuery¶

• Fixed false positive EWI-0073 in BigQuery transaction replacers.

SQL Server¶

• Fixed CONVERT with GETDATE in DEFAULT expressions.

• Fixed missing comma before CONSTRAINT in CREATE TABLE.

SSIS¶

• Fixed identifier sanitization for Snowflake root task names.

• Fixed SSIS ExecutePackage connection manager-based references.

General¶

• Fixed telemetry and logs directory permissions.

• Fixed error code when connection test fails.

• Fixed default object type from views to view in selector report creation.

• Fixed AI Conversion “not processed” typo in results display.

Informatica¶

• Enabled Informatica PowerCenter Replatform support in the UI.

Oracle¶

• Added CONNECT_BY_ROOT pass-through support.

PostgreSQL¶

• Added support for the EXTRACT built-in function.

RedShift¶

• Added support for the EXTRACT built-in function.

• Added support for the HLL aggregate function.

SQL Server¶

• Added OBJECTPROPERTY() function conversion support.

• Added UNPIVOT operator translation support.

• Added support for GOTO/LABEL statement translation to nested procedures.

• Added SQL Server Agent Job closure support with ownership, tagging, notification, and multi-schedule fan-out.

• Added CREATE SYNONYM statement support.

SSIS¶

• Added Microsoft Cache Transform (Microsoft.Cache) translation to dbt.

• Added --simplify-ssis-dataflow option for SSIS conversion.

General¶

• Added Teradata driver upload functionality for two-sided AI Verification.

• Added carousel with CLI and Cloud Data Migration information.

• Enabled Cloud Data Migration by default.

• Added ability to deploy objects when status is verified by user.

SQL Server¶

• Added defensive guards to GOTO/LABEL decomposition logic.

• Added WAITFOR TIME commenting with Functional Difference Message (FDM).

• Added SSC-FDM-TS0055 for database-scoped CREATE USER.

• Added FDM for global temporary tables.

• Changed DEALLOCATE to use FDM instead of EWI.

SSIS¶

• Normalized reusability tracker keys and conditionally suppressed SSC-EWI-SSIS0008.

• Simplified SSIS FileSystem Task SQL output.

General¶

• Enhanced AI Verification with estimation formulas retrieval.

• Added validation for two-sided AI Verification source files (UTF-8 no BOM, LF line endings).

• Improved engine crash exception propagation to provide clearer error messages.

• Added TaskManager crash diagnostics for Windows CVT0008 errors.

• Added filename generation in the element inventory.

• Removed VARCHAR length limits from control variables schema.

RedShift¶

• Fixed database not being added to qualified object names on extraction.

General¶

• Fixed code conversion failing when using offline mode.

• Fixed consolidated source not being preserved across repeated code extractions.

• Fixed error message to show supported languages for invalid source language errors.

• Fixed rendering of icons for UTF-8 consoles.

Informatica¶

• Added support for the SUM aggregate function translation to Snowflake.

• Added support for the MIN aggregate function translation to Snowflake.

• Added support for GET_DATE_PART to Snowflake DATE_PART translation.

• Added support for IS_NUMBER function translation to Snowflake.

• Added support for IS_DATE inline translation to Snowflake TRY_TO_DATE.

• Added support for TO_DATE function translation to Snowflake.

• Added Source Qualifier Pre/Post SQL, session overrides, and variable migration support.

• Added Sorter transformation to dbt translation with ORDER BY, DISTINCT, and LOWER support.

• Added Sequence Generator transformation translation to ROW_NUMBER().

SQL Server¶

• Added SQL Server Agent Job support for CRON schedule building, sp_send_dbmail, and sp_add_category translation.

• Added SCOPE_IDENTITY() transformation to Snowflake time-travel queries.

• Added support for DROP PROCEDURE statement with type signatures.

SSIS¶

• Added ADO NET Source (Microsoft.DataReaderSourceAdapter) translation to dbt.

PowerBI¶

• Added implementation flag support on entity connector types.

General¶

• Added Cloud Data Exchange Worker for data migration workflows.

• Added infrastructure diagnostics for Cloud Data Migration.

Hive¶

• Included table naming convention support.

Oracle¶

• Added INSTR negative position workaround for position = -1.

SQL Server¶

• Added CONVERT with style mapping to TO_DATE/TO_TIMESTAMP.

• Added CREATE STATISTICS commenting with SSC-FDM-TS0048 Functional Difference Message (FDM).

• Replaced EWI-0035 with specific FDMs for CHECK constraint handling.

• Removed partition placement ON clause from constraints in CREATE TABLE.

• Added new Error Warning Information (EWI) for OBJECT_SCHEMA_NAME.

• Updated SSC-FDM-TS0035 trigger FDM message.

SSIS¶

• Improved per-executable resilience, pipeline column enrichment, and GUID resolution.

• Added package name as a prefix of the Snowflake task names.

Teradata¶

• Included FORMAT literal in TD0040 message.

General¶

• Deprecated the selector for code deployment, restricting it to SQL Server and Redshift only.

• Improved conversion performance for code-only projects by disabling registry generation.

• Renamed legacy_structure project type to Full and Code for clarity.

• Improved assessment cleanup by removing engine output after execution.

• Removed legacy converted folder references from the project structure.

• Added AI verification status column with parent tooltips in the UI.

• Cloud Data Migration now uses images from the SPCS Image Registry directly.

Oracle¶

• Fixed a variable named current_date being incorrectly converted to a function call.

RedShift¶

• Fixed database not being recognized in Redshift code units.

• Fixed EWI on out cursor transformation.

SQL Server¶

• Fixed FOR XML PATH('') transformation dropping expressions.

SSIS¶

• Fixed version upgrade emitting malformed XML.

• Fixed nested Jinja in dbt source() calls for VariableTable access mode.

General¶

• Fixed language flags to avoid repeated short names.

• Fixed code conversion input and output path resolution in the UI.

• Fixed AI code conversion on Windows by preparing report paths before zipping.

• Fixed AI Conversion status display and progress tracking.

• Fixed ArrangeLog Logger not being disposed, causing Windows file locking.

General¶

• Added an assessment report page with a code tag component for viewing conversion results.

General¶

• Improved code deployment to include dependencies when a WHERE clause filter is defined.

• Scoped the new project structure and registry to SQL Server and Redshift platforms.

• Added source identifier tracking to schema objects during extraction.

• Updated application update notifications to display the download URL directly.

General¶

• Fixed broken Data Validation endpoints.

• Fixed a terminal output issue where progress bars could collide with other output.

Hive¶

• Added support for the GET_JSON_OBJECT function.

SQL Server¶

• Added non-ASCII identifier double-quoting transformation for Transact-SQL.

Teradata¶

• Added support for Teradata file extraction.

SSIS¶

• Added conversion support for Microsoft.CharacterMap transformations.

• Added conversion of sp_add_jobstep for SQL Server Agent Job orchestration.

Informatica¶

• Added conversion of the TRUNC function to Snowflake TRUNC.

• Added conversion of the DECODE function to Snowflake.

• Added conversion of the ADD_TO_DATE function to Snowflake DATEADD.

• Added conversion of the LTRIM function to Snowflake.

• Added conversion of the RTRIM function to Snowflake.

• Added conversion of the MAX aggregate function to Snowflake.

General¶

• Added support for iteratively adding code units to a project.

• Added local report generation for Cloud Data Migration.

• Integrated Testing Orchestration (seed, capture, and validate) into the desktop application.

SQL Server¶

• Added a Functional Difference Message (FDM) for SET IDENTITY_INSERT statements, which are now commented out during conversion.

PowerBI¶

• Improved Power BI version integration and applied general cleanup.

General¶

• Integrated the resync command with the conversion engine for re-scanning modified converted files.

• Integrated resync into the code accept workflow to keep issue metadata in sync.

• Enhanced the selection summary panel layout for smaller window sizes.

• Disabled connections with invalid authenticators in Snowflake.

• Extended the close-app guard to cover active Code Extraction jobs.

• Added application type information to CSV reports.

• Improved IPC channel error handling.

SQL Server¶

• Fixed an issue where semicolons in SQL Server passwords caused connection failures.

• Fixed alias duplication in UPDATE...FROM translation.

• Fixed XML.value() instance parsing and absolute-path handling.

SSIS¶

• Fixed FuzzyLookup to only propagate passthrough columns.

• Fixed ExcelSource not displaying Error Warning Information (EWI) markers in dbt models.

Informatica¶

• Fixed unresolved EWI description placeholders for Mapplet subtypes.

PowerBI¶

• Fixed SQL extraction from Power Query connections when schema and object names use double quotes without an ending semicolon.

General¶

• Fixed account locator extraction for AI Code Conversion when using Key Pair authentication.

• Fixed an issue where the Key Pair passphrase argument was incorrectly omitted when empty or null.

• Fixed an issue where code formatting could cause errors.

• Fixed a race condition that could affect job initialization during concurrent operations.

• Applied general stability fixes.

SSIS¶

• Added conversion support for ExcelDestination components to Snowflake dbt.

• Added conversion support for SQL Server Agent Job TSQL command references.

• Added a catch-all replacer for unsupported SQL Server Agent Job procedures.

• Added conversion of sp_delete_job to DROP TASK IF EXISTS for SQL Server Agent Jobs.

• Added conversion of sp_update_job to ALTER TASK ... SUSPEND/RESUME for SQL Server Agent Jobs.

• Added conversion support for Microsoft.FileSystemTask transformations.

• Added conversion support for Microsoft.FuzzyLookup transformations.

• Added support for SSIS Project.params conversion.

SQL Server¶

• Added conversion of WAITFOR DELAY to CALL SYSTEM$WAIT.

General¶

• Added Single Sign-On (SSO) support for executing AI Verification jobs.

• Added Time-based One-Time Password (TOTP) Multi-Factor Authentication (MFA) support.

• Added a resync command for re-scanning modified converted files to update issue metadata.

• Added estimation report generation support.

• Added the last job status per code unit on the selection page.

SSIS¶

• Improved support for older SSIS package formats with automatic version upgrade.

RedShift¶

• Improved the layout of the Redshift connection form.

General¶

• Improved specification and migration report artifact downloads to include terminal job status.

• Extended the close-app guard to cover data migration, data validation, and deployment jobs.

• Improved connection error messages with better formatting.

• Improved log and report file path handling.

• Added individual object listing in the code deploy success summary.

• Added validation for AI Verification job files in the project directory.

• Added application type information to the assessment report.

• Added a flag to skip split operations during code extraction.

SQL Server¶

• Fixed the double-dot identifier transformation to correctly reference the latest active database.

• Fixed BEGIN TRAN syntax conversion to Snowflake.

SSIS¶

• Fixed handling of empty XML elements and hardened upgrade error handling.

RedShift¶

• Fixed Redshift code unit name matching in AI Verification.

General¶

• Fixed Data Validation Framework (DVF) progress corruption.

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

Added¶

• Added “ANSI/TERA Session Mode” and “Use COLLATE for Case Specification” settings:

  • ANSI mode with COLLATE.

  • ANSI mode without COLLATE.

  • TERA mode with COLLATE.

  • TERA mode without COLLATE.

• Support parsing of GENERATED TIMECOLUMN column option.

• Support parsing of TD_NORMALIZE_MEET function.\

Fixed¶

• Fixed inconsistencies in column names when it comes to Snowflake reserved keywords.

• Parsing errors in PARTITION BY RANGE_N clause.

• Improved support for COALESCE expression.

Fixed¶

• Some functions were incorrectly marked as a pending functional.

Fixed¶

• Renaming feature now contemplates function with parameters.

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

Fixed¶

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

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

Fixed¶

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

Fixed¶

• Code missing when converting a function with CONNECT BY.

Fixed¶

• Flag TeraModeForStirngComparison is set to true as default.

Fixed¶

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

Fixed¶

• Code missing when converting a function with CONNECT BY.

Fixed¶

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

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

Fixed¶

• Issue with WITH DISTRIBUTION and CLUSTERED in table creation.

Fixed¶

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

Fixed¶

• Conversion of stored procedures inside macros is now supported.

• StringSimilarity Teradata Function is now converted successfully

Fixed¶

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

Fixed¶

• Create a Stored Procedure to compliance the same flow as in Teradata (StoredProcedure inside a Macro)

• Use a UDF Helper to emulate the functionality given for a VALIDTIME column in Teradata

Fixed¶

• Empty Create Statement

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

Fixed¶

• UDF called “PERIOD_TO_TIME_UDF” is now included as part of the code output if it is used in the converted code.

• UDF called “DATE_TO_PERIOD_UDF” is now included as part of the code output if it is used in the converted code.

Fixed¶

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

Fixed¶

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

Fixed¶

• Cast to CHAR/CHARACTER causing parsing error

Fixed¶

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

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

Fixed¶

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

Teradata¶

Added

• New conversion setting for TERA MODE strings comparison transformation

Fixed

• Anonymous block of code converted to a stored procedure.

• PRIMARY TIME INDEX not being parsed.

SQL Server¶

Fixed

• Empty stat should not be classified as pending functional

• SQL report has a text referring to Teradata

Oracle¶

Added

• Oracle function conversion to Functions (single statement)

Fixed

• DATE_TO_RR_FORMAT_UDF is added in the view conversion but is not part of the SC output

Teradata¶

• Added translation for EXTRACT function.

• Fix translation in procedure when there is a presence of IMMUTABLE/VOLATILE.

• Improved translation of EXTRACT_TIMESTAMP_DIFFERENCE_UDF to support timestamp as parameter.

SQL Server¶

• Improved error handling when translating long-named columns.

Oracle¶

• Added translation for STANDARD_HASH function.

• Improved the parser to be able to read DBMS_DATAPUMP.detach.

Teradata¶

• Added translation for PREPARE STATEMENT, ACTIVITY_COUNT, DAY_OF_MONTH, DAY_OF_WEEK, WEEK_OF_CALENDAR, MONTH_OF_CALENDAR.

• Added translation for CREATE SCHEMA.

• Fixed INTERVAL literal not converted in minus operations.

• Improved parser capability to read LATEST as a column name.

Oracle¶

• Improved translation on PL/SQL parameter data types: VARCHAR and INTEGER.

• Fixed duplicated comments in PL/SQL procedure declarations.

SQLServer¶

• Fixed EXECUTE AS statement wrongly transformed to EXECUTE IMMEDIATE.

• Fixed temporary table generated erroneously.

• Improve parsing of WITH xmlnamespaces statement.

Oracle¶

• Fixed translation for columns with whitespaces in CREATE VIEW.

• Improved description of SSC-EWI-OR0042.

• Improved parsing of ACCESSIBLE BY clause and SQL_MACRO option from CREATE FUNCTION.

• Improved parsing of the DECLARE statement.

SQLServer¶

• Fixed translation of BEGIN…END showing pending functional equivalence.

• Added translation for FOR XML PATH clause.

Teradata¶

• Added an EWI 0073 to PREPARE statement.

• Added OR REPLACE to CREATE TABLE

Oracle¶

• Added translation for Materialized View’s REFRESH_MODE property.

• Improved parsing capability to read MODEL clause and to read CREATE VIEW alternate routes.

SQLServer¶

• Added translation of SET ANSI_NULLS.

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

Oracle¶

• Improved parsing capability to read JSON_OBJECT and JSON_ARRAYAGG built-in functions.

SQLServer¶

• Improved Missing Object References report’s content.

• Improved robustness during the semantic analysis phase and translation phase.

Teradata¶

• Improved translation related to date handling.

• Improved parsing capability to read code that contains block comments.

• Improved parsing capability to read NOT NULL column option before the data type declaration in a table.

• Improved the functionality of TIMESTAMP_DIFFERENCE_UDF and EXTRACT_TIMESTAMP_DIFFERENCE_UDF.

SQL Server¶

• Improved translation for ALTER TABLE CHECK constraint.

Teradata¶

• Added translation for CONTINUE HANDLER.

• Added new parsing capability for BYTE data type.

• Improved binding variable translations.

Oracle¶

• Added and improved parsing capability to read EXPLAIN PLAN statement, U-Literals and CTAS.

• Improve CURSOR translation when it has to define a cursor with object_construct.

• Improved translation of procedure parameters avoiding deployment errors.

SQLServer¶

• Added translation for DB_ID function.

• Added basic translation for CREATE SCHEMA.

• Added an FDM for CREATE INDEX.

• Improved ALTER TABLE translation.