2020

Details about the releases of Snowflake SnowConvert for Teradata during 2020.

Release 1.5.5

Conversion Core 1.9.2

Added

  • CREATE SCHEMA Statement

  • COMMENT Statement

Fixed

  • Parsing error fixes for some column names that are keywords

  • Add warning for DELETE ALL statements

  • Migrating duplicated labels in BTEQ should rename them

  • Critical issue with Date Formats YYYYMMDD

  • Critical Issue with Date Formats YYYYMM

  • DELETE statement improvements

  • [Procedure] In Predicate improvement

  • [Procedure] Preserve DEFAULT CURRENT_TIME for variable on SP migrations

  • TRUNC not being added for integer operations

  • Whenever the migration tool comments out code a mark should be added

Release 1.5.4

Conversion Core 1.9.1

Fixed

  • [Performance] Fixed performance issue by changing the catching system.

  • [Procedures] FETCH method for Cursors when there are no rows

  • [Procedures] Improve error handling for procedure code

  • [BTEQ] BTEQ conversion creating cartesian join

  • [BTEQ] COMMIT statement added for BTEQ

Release 1.5.2

Conversion Core 1.9.0

Added

  • [Assessment] Issues Breakdown Summary

  • [Tables] Multiple foreign key translations

  • [Queries] CAST(Column as CHAR(n))

  • [Queries] CSUM and MSUM function translation

  • [Proc] CASE WHEN translation

  • [Proc] BEGIN/END REQUEST Stat

  • [Btq] CREATE ERROR TABLE

Known issue: macOS - the Start Over button can cause unexpected behavior.

Release 1.4.2

Conversion Core 1.8.1

Added

  • [Assessment] Data Lineage Report

  • [Assessment] Assessment for scripts

  • [Expressions] XMLAGG common pattern translation

  • [Functions] Translate CHARACTER , MAXIMUM , MINIMUM , AVERAGE

  • Performance improvement migrating Procedures

Fixed

  • [Expressions] Add a warning for CAST(var1 as VARCHAR(N)) when needed

  • [Expressions] Named Clause translation

  • [Expressions] IN Statement translation improvement

  • Additional foreign keys translation

  • [BTEQ] Errors when object name has &

  • [Procedures] FOR...CURSOR Statement translated to EXEC helper function

Release 1.4.0

Conversion Core 1.7.1

Added

  • TERADATA MONTH or DAY conversions

  • [Procedures] CURSOR migration improvements

  • [Assessment] Highliting the section Notes on Output Files Not Generating of the Assessment Report

Fixed

  • Performance issue when converting very big file.

  • Stack overflow issue when parsing more than 4000 SELECTs

  • COALESCE function translation

Release 1.3.6

Conversion Core 1.6.6

Added

  • [Assessment] Improved assessment report accuracy

  • [Procedures] COLLECT Statistics conversion

  • [Procedures] IS IN Statement conversion

  • [Procedures] New ERROR HANDLER and EXEC

  • [Procedures] DBC table mapping

Fixed

  • [Procedures] Binding variables usage improvement

Release 1.3.5

Conversion Core 1.6.3

Added

  • Improved assessment report template and accuracy

  • INTERVAL keyword migration

  • [Procedures] Convert CASE WHEN to IF syntax

  • [Procedures] Convert operators such as NOT=, ^=, NOT EQ and ^EQ

Fixed

  • [Procedures] Binding variables usage improvement

Release 1.3.4

Conversion Core 1.6.0

Added

  • Macros: Convert SELECT and return a temporary table for the results of the SELECT

  • Procedures: Convert Statements using Binding Variables

Fixed

  • Parsing errors on Tables and Views due to some keywords like USAGE, EXCEPTION, Offset

  • Assessment: Accuracy at the level of Current Minimum Conversion Rate by lines of code.

  • Tables: DEFAULT values conversion improvement to prevent Type Mismatch Error.

  • Procedures: TRIM function conversion improvements

  • Procedures: Process Hexadecimal literals in order to prevent functional errors.

  • Procedures: COLLECT STATS should be commented out.

Release 1.3.2

Conversion Core 1.5.0

Fixed

  • BTEQ: Be able to parse identifiers starting with Ampersand (&)

  • Procedures: Conversion Issues related with CAST Expressions

Release 1.3.0

GUI

  • Users can specify the file encoding in the settings.

Conversion Core 1.4.3

Added

  • Support to specify the file encoding.

  • Handle alises when used for TEMPORAL tables.

Fixed

  • TRUNC being applied to non-integer calculations.

  • NAMED expression in WHERE clause.

  • SELECT clauses need to be specifically ordered.

  • DATABASE dbname statement is not valid in Teradata.

  • SELECTCURRENT_TIMESTAMP Error when applying CAST transformation whitespace eimination causes a bad syntax statement

  • ALIAS REFERNCE IN JOIN OR WHERE CLAUSE

  • TABLE - Partition by Column Parsing Issue

  • Telemetry] [Report] Implement & send report to telemetry

  • Telemetry] [Metadata] Extend metadata sent via telemetry

  • Telemetry] [AssessmentReport] Differentiate Warnings from Issues in reports

  • DML - MINUS function

Release 1.2.0

Conversion Core 1.3.0

Added

  • Mapping for EXPORT RESET statement using the helpers.

  • Mapping for EXPORT REPORT statement using the helpers.

  • Mapping for EXPORT INDICDATA statement using the helpers.

  • Mapping for IMPORT statements using the helpers.

  • Assessment counter for Primary Keys.

Fixed

  • Tags were being removed from Join Indexes.

  • CREATE TEMP TABLE WITH DATA clause was wrongly converted and just generates an invalid statement.

  • Fixed many existing counters for the assessment.

  • Table DDL Adjustments.

  • YEAR FROM DATE should be converted to YEAR FROM CURRENT_DATE.

  • HAVING Clause needs to be placed at the end of a query.

  • USING clause was no properly parsed.

  • BTEQ: LIMIT statement was no properly parsed.

  • BTEQ: .RUN statement was no properly parsed.

  • BTEQ: EXIT statement was causing crashes.

  • BTEQ: Single Line IF statements with OS staments are only partially converted.

Release 1.1.4

GUI 1.1.4

Added

  • New settings screen and initial screen for Oracle and Teradata.

  • New Complete Results Screen in GUI.

  • Supporting of BaseConverter and common initialization for converters, centralized licensing mechanism.

Fixed

  • Fixing issue with conversion error page which not open the log folder.

  • Fixing a bug related to string resources loading for assessment execution mode.

Conversion Core 1.1.3

Added

  • BTEQ: Improved error handling for GOTO statement.

  • Assessment: removed Achievable Automation Conversion Rate.

  • Assessment: estimated number of unique issues left blank.

  • Assessment: updated text in the DATABASES section.

  • Added performance warnings to INSERT and DELETE statements when inside of a loop.

  • Added BTEQ conversion for RUN command.

  • Support CAST Data-type Conversion transformations

    Fixed

  • BTEQ: migration of OS command should use """.

  • BTEQ: GOTO ERRORS causes a conversion error.

  • Fixed a problem when analyzing input directory statistics

  • SQL statement in BTEQ can throw a conversion exception.

  • Fixed a problem when passing the settings from the UI.

  • TABLE - Convert UNIQUE INDEX

  • Conversion errors in BTEQ with Date Format

    Runner 1.1.1

    Fixed

  • Fixing issue with execution parameters

Release 1.0.3

GUI

Added

  • Terms and Conditions are now also accessible from the application menu.

    Fixed

  • Hitting enter after entering the license key clicks the Discard button.

Conversion Core 1.0.2

Added

  • Support for RENAME TABLE.

  • Support for ROLLBACK Statement in procedures.

  • Support for DROP INDEX with column name and ORDER BY.

  • Support for CREATE TABLE WITH DATA PRIMARY INDEX(CODE).

  • The counter for NUMBER formats for the Assesment Doc includes DECIMAL and NUMERIC.

  • Logging when files are not generated due to an exception.

    Fixed

  • Casting/adding functions when not required.

  • UPDATE statement with the update table uses the same alias as one of the tables in the FROM clause.

  • CSUM should be converted to SUM window function.

  • SNOWFLAKE does not support especifying new column names as in Teradata.

  • HOUR TO SECOND(0) not being picked.

  • SELECT Statement gets chopped during conversion.

  • DELETE statement in snowflake must use the USING clause for additional tables.

  • Error translating UPDATE statements when a temporary table is used.

Release 1.0.1

GUI

  • Adding support for Multiload, FastLoad and Tpump extensions for SnowConvert.

Conversion Core 1.0.1

Added

  • Do not generate empty python methods when doing BTEQ migrations.

  • Support BT and ET as Begin Transaction and End Transaction in BTEQ.

  • Transformation for TITLE and NAMED data attributes in Procedures.

  • Params are escaped inside Procedures transformations.

  • Updated the definition of log_on method in snowconvert_helpers.py.

  • The helper file snowconvert_helpers.py is copied only at the root directory.

Fixed

  • View ordering and missing schemas.

  • "NOT CASESPECIFIC" does not work in Snowflake.

  • Not forwarding alias names defined as "NAMED AS".

  • FOR LOOP statement not parsed correctly.

  • Reported conversion coverage and assessment coverage being different.

  • Some Multiset tables not parsing correctly.

  • TRIM (BOTH FROM ' TEST ') is copied as it is.

  • Comments removed from View definition and losing formatting for all SQLs.

  • Reported errors in snowconvert_helpers.py python file.

  • Exception in the Symbol's table when files in different directories have the same name.

  • Some BTEQ statements being trimmed in the converted coded.

  • Keep Label ordering in conversion of BTEQ to Python.

  • CURRENT_DATE statement is being converted with quotes "CURRENT_DATE".`

  • Wrong Parenthesis after migration for DT statement.

  • Many errors in the conversion of SET and DECLARE statements in Procedures.

  • String Terminator in BTEQ Queries is being concatenated with another string terminator.

Release 1.0.0

GUI

  • Using Product Licensing API 3.0.0.

  • Update crash screen to allow users to send crash report information.

Conversion Core 1.0.0

  • Conversion rate for Macros now counts partial conversions.

  • Added support for ABORT statements conversion.

  • Added support for ECHO statement conversion.

  • Fixed some procedures being converted with an empty body.

  • Fixed a reported error that prevented the conversion of Multiload files.

  • Fixed missing parameter types in converted Procedures/Macros.

Release 0.5.8

Conversion Core 0.3.5

  • Added support for conversion of REPEAT and LOOP statements.

  • Added support for multiple DECLARE HANDLER in a Stored Procedure.

  • Bugfixes in the conversion of Stored Procedures.

  • Added support for conversion of GLOBAL TEMPORARY TABLE.

Release 0.5.6

GUI

  • Check for updates menu option available.

  • Modals styles improvements.

  • Display execution mode when running in Assessment Mode in SnowConvert UI.

  • New Snowflake SnowConvert logo.