SnowflakeDocumentation Home

2021

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

Release 2.0.23 - December 21st, 2021

Updated Conversion Core 3.2.13

Fixed

  • The default value in a column gives a parsing error

  • Removed the unused options avoidTruncatedDataInCast, warnIfCastMightTruncateData and useLeftFunctionInTruncatedCast

  • Fix multiple EWIs not appearing in the assessment reports

  • INTERVAL not recognized in addition and subtraction of Datetime values

  • STRTOK_SPLIT_TO_TABLE not being transformed

Added

  • Support REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR functions with COLLATE arguments

  • Conversion of NEW ST_GEOMETRY

Release 2.0.22 - December 7th, 2021

Updated Conversion Core 3.1.43

Fixed

  • Update conversion for NULLIFZERO function

  • Not recognizing unsupported INTERVAL type

Added

  • ET or END TRANSACTION is now supported when used in SQL files

Release 2.0.21 - November 22nd, 2021

Updated Conversion Core 3.1.24

Fixed

  • UDF helpers are hardcoded to use PUBLIC schema

  • Extend MSCEWI2015 description. Deprecate MSCEWI2046

  • T12 scripts parsing error when a $variable is used as a statement

  • T12 scripts parsing error related with $variable in LOGTABLE and BEGIN IMPORT statements

  • Empty file migration is incorrect

  • Function CHAR_LENGTH is not translated

Added

  • General improvements to casts to string for both ANSI and Teradata syntaxes

  • Support Default Period Constructor transformation

Release 2.0.20 - November 8th, 2021

Updated Conversion Core 3.1.21

Fixed

  • Fix SQL Statements parsing recovery in T12 scripts

  • Cursor with locking statement is not parsed

  • Some comments are missing in the Stored Procedures Header

  • Some MACROS are not identified in assessment reports

Added

  • Extended support for TO_CHAR function migration for both datetime and numeric types

  • Improvements to preprocessing scripts, more info here

  • Generation of HTML assessment report

Release 2.0.19 - October 25th, 2021

Updated Conversion Core 3.1.10

Fixed

  • Bug in NOT LIKE ALL syntax transformation

  • Literals in VIEW columns require an alias

  • Missing statement in generated code

Added

  • Python helpers technical documentation website

  • Python helpers logging improvements described here

  • Authenticator parameter in python helpers connection method

  • Support for special Teradata MERGE syntax

  • Parsing support for SEQUENCED and NONSEQUENCED VALIDTIME clauses

Release 2.0.18 - October 11th, 2021

Updated Conversion Core 3.1.9

Fixed

  • Parenthesis in a CURSOR FOR causes code to be commented out.

  • Issues in INSERT clause using MERGE statement.

  • License file not saved in temp location when SnowConvert is executed with a root user.

  • Parsing error for EXPAND ON statement.

Added

  • Improvement to generated Python code, adding indentation to Exec command arguments. An example is shown in the following image.

  • Changing argument's binding format in Procedures, from a question mark (?) to a numbered index (:1, :2). An example is shown in the following image.

  • Casting string nulls to varchar(1) in VIEWs definition.

  • Support for PERIOD and END functions along with a new warning for period-related types/functions

  • Minor UI updates (some colors changed, and buttons placement). New images are displayed in the Using SnowConvert section.

Release 2.0.17 - September 27th, 2021

Updated Conversion Core 3.1.6

Fixed

  • Incorrect migration forQUERY TAGstatements.

  • Stack overflow caused by VIEWs containing parameters with the same name as columns of the SELECT.

Added

  • Implicit conversions for numeric/dates parameters for several functions. More information can be found in the EWI that is generated for non-literal cases.

  • Support for file extensions.ddl and .dml, they are treated like any other.sqlfile, but the original extension is preserved.

  • Warning for possible compilation errors in Snowflake when using subqueries in OUTER JOIN statements. More info can be found on the EWI page.

  • New Logo for SnowConvert and minor UI update (some colors changed). New images are displayed in the Using SnowConvert section.

Release 2.0.16 - September 14th, 2021

Updated Conversion Core 3.1.3

Fixed

  • Transformation improvements for function STRTOK_SPLIT_TO_TABLE

  • Null pointer exception in Views and in SELECT with alias

  • Remove RANGE_N warning when is used within the PARTITION BY

  • Execute Immediate with concatenation is not working

  • Macro being translated as a procedure with double schema name

  • Parsing error: Last valid token was ''^''

  • Internet connection timeout taking up 2 minutes

Added

  • Add helpers region tags in macros translated to procedures.

  • TD_DAY_OF_MONTH function transformation

  • MCHARACTERS function transformation

  • Transformation for BYTES/BYTE function and hexadecimal byte literals

Release 2.0.15 - September 1st, 2021

Updated Conversion Core 3.1.2

Fixed

  • Parsing recovery for fields with empty space in their name

  • Issue with results from subqueries in Stored Procedures

  • Exception thrown when converting names with a different encoding.

  • Unnecessary warning added when converting special character in identifiers

  • Fix for parsing error inconsistent count

  • Delete alias should not be qualified.

Added

  • Parsing recovery for .mload fields with empty space in their name.

  • STRTOK_SPLIT_TO_TABLE transformation improvement

  • Implicit conversion behavior of parameters for functions INDEX, POSITION

  • Improvements in procedure helpers and tablelist functionality

  • None Schema functionality

  • OTRANSLATE function transformation

Release 2.0.14 - August 18th, 2021

Fixed

  • The confirmation pop-up window for canceling the migration process is not displayed correctly.

Release 2.0.13 - August 16th, 2021

Updated Conversion Core 3.1.0

Fixed

  • Quotes in comments causing a compiler error

  • Missing statement in output code

Added

  • Support for STROK_SPLIT_TO_TABLE function

  • Support for TD_LEFT function

  • Support for TD_RIGHT function

Release 2.0.11 - August 4th, 2021

Updated Conversion Core 3.0.22

Fixed

  • Removed unnecessary assignment after EXEC in SP.

  • MDIFF function translating to missing UDF.

  • BTEQ Stub Generation for unsupported Statements

    • .LOGON

    • .SET WIDTH

    • .SET SEPARATOR

    • .SET NULL AS

    • .SET SIDETITLES

    • .LOGMECH

    • .SET RECORDMODE

  • BTEQ file execution transformation

  • INTERSECT ALL not supported

  • Fix Stack Overflow due to a circular reference when top-level objects invoke each other

  • NOTFOUND Helpers generated when are not required

Added

  • Udf Helper file reorganization

Release 2.0.10 - July 19th, 2021

Updated Conversion Core 3.0.20

Fixed

  • Unknown custom data type is causing to comment a lot of code

  • CAST NULL AS INT has unnecessary Truncate

  • Unexpected behavior when the input path is very long

  • Parsing issue with MERGEBLOCKRATIO with PERCENT

  • Cursor naming declaration and ACTIVITY_COUNT update inside cursor

  • NOWAIT statement that is part of the LOOKING is causing a parsing error

  • Trim leading being marked with Collation warning

  • MSC-ISSUE was renamed to MSC-ERROR in all the reports and output code

  • [Stored Procedures] Improved generation of MSC comments for better readability

  • [Stored Procedures] The INTO function overrides the values set by the ERRORHANDLERS function

  • [Stored Procedures] EXIT HANDLER doesn't work properly

Added

  • [Stored Procedures] Helpers Code Regions, and better code organization.

  • EWI about procedures with out (or inout) parameters

  • SHOW command support

  • Transformation for REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR.

Release 2.0.9 - July 7th, 2021

Updated Conversion Core 3.0.17

Fixed

  • LEAD cannot be used as a column identifier