2022

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

Release 3.0.260 - December 26th, 2022

SnowConvert Core 13.0.31

Added:

Support DAYNUMBER_OF_MONTH function with the exception of the ISO parameter, it is now transformed to DAYOFMONTH

Fixes and improvements:

Fix multiload DML labels with multiple actions causing the UPSERT operations transformation to fail due to parsing errors
Fix multiload UPSERT transformation generating MERGE statements with bad syntax in Snowflake

Release 3.0.257 - December 19th, 2022

SnowConvert Core 13.0.16

Added:

Support NORMALIZE clause

Fixes and improvements:

Duplicated schema added inside execute immediate in scripts

Release 3.0.253 - December 12th, 2022

SnowConvert Core 12.0.0

Added:

Support finalwdname column for dbc.dbqlogtbl table, is now transformed to session_id
Add support XMLAGG function when no arguments were added, continues being transformed to LISTAGG function

Fixes and improvements:

Inconsistent transformation of DBC columns references due to aliases
MLOAD critical exception due to $ identifiers inside RUN FILE
Preserve table constraint names, it was previously lost when transformed to an ALTER TABLE
Parsing error caused by CONDITION_IDENTIFIER inside GET DIAGNOSTICS EXCEPTION statement
Transformation failing when using ATTACH name as a column alias
CALL DBC.SysExecSQL inner string with variables is processed as an embedded SQL statement and transformed accordingly
Mark COMPOUND labels and associated LEAVE statements as not supported by Snowflake Scripting

Release 3.0.240 - November 21st, 2022

SnowConvert Core 11.0.108

Added:

Support Main Log Table (DBQLogTbl) and its columns StartTime and FirstStepTime
Support Expand On clause for it uses Anchored Interval
Add --RenamingFile conversion parameter for the CMD tool only, it allows specifying new names for objects such as Tables, Views, Procedures, Functions, and Macros utilizing a .json file. For more information visit the documentation
The default DB Object Name configuration option is now None resulting in all migrated objects now being without PUBLIC schema
The DB Object Name configuration Public has been removed, its behavior can still be replicated with Database

Fixes and improvements:

STRTOK_SPLIT_TO_TABLE with ORDER BY clause making the tool crash
Missing column name definitions on queries when the column has cast to CHAR

Release 3.0.224 - October 31st, 2022

SnowConvert Core 11.0.28

Added:

Added new code arrange functionality to prepare the code before the migration, for an in-depth explanation visit the documentation

Support WeekNumber_Of_Quarter function, is now transformed to WEEKNUMBER_OF_QUARTER_UDF
Support DayNumber_Of_Year function, is now transformed to DAYOFYEAR
Support cast to date with syntax {d '2022-09-10'} from Teradata version 16.2, is now transformed to DATE('2022-09-10')

Fixes and improvements:

Enclose column names containing the character '#' between double quotes to avoid syntax error
Comment the uses of NORMALIZE as it is not supported at this time

Release 3.0.188 - October 24th, 2022

SnowConvert Core 10.0.0

Fixes and improvements:

Line breaks not been preserved inside embedded code as string resulting in execution errors.

Release 3.0.172 - October 10th, 2022

SnowConvert Core 9.2.72

Added:

Support SOUNDEX function, is now transformed to SOUNDEX_P123
Support BTEQ error block conditions to Snowflake Scripting
Support CALL DBC.SysExecSQL, is now transformed to EXECUTE IMMEDIATE

Fixes and improvements:

Interval day to second migrated to VARCHAR, the length of the varchar was increased to 21 to avoid runtime errors
Substring function transformation now supports both ANSI and Teradata syntax avoiding the loss of parameters
Alias name assigned to TD_UNPIVOT is preserved
Additional column references not resolving in TD_UNPIVOT

Release 3.0.176 - September 28th, 2022

SnowConvert Core 9.2.23.0

Fixes and improvements:

Date column plus cast to interval value, the Snowflake translation now uses DATEADD function instead

Release 3.0.166 - September 26th, 2022

SnowConvert Core 9.2.6

Added:

Support variable placeholders from BTEQ to Snowflake Scripting transformation
Support Period Data Type separation on flag demand
Add Period Data Type separation as a conversion option to the UI

Fixes and improvements:

Missing support for SELECTS with TOP n TOP m percentage
Support concatenation !! operator corner case

Release 3.0.158 - September 20th, 2022

SnowConvert Core 9.0.69

Added:

Support LAST function for period data type

Fixes and improvements:

Double single quotes not getting added to dynamic SQL strings
Dynamic SQL preserve change of lines
TD UNPIVOT JOINED causing parsing errors
UESCAPE in column name not being resolved in a view causing to comment all the code

Release 3.0.154 - September 14th, 2022

SnowConvert Core 9.0.48

Fixes and improvements:

Fixed bug that causes UI to not display the text in certain windows

Release 3.0.148 - September 12th, 2022

SnowConvert Core 9.0.37

Added:

Provide decimals to conversion rate values in TopLevelObjects and TopLevelQueries reports
Support BEGIN TRANSACTION in LOCKING Request Modifier as part of the SQL Request

Fixes and improvements:

Column name being changed when inside a subquery

Release 3.0.125 - August 29th, 2022

SnowConvert Core 7.11.119.0

Added:

The target language for Stored Procedures, Macros and BTEQ by default is now SnowScripting
Bteq log_on method now allows the connection using OAUTH token associated with snowconvert-helpers 2.0.14

Fixes and improvements:

Cast Varchar to Timestamp format error
Improve conversion for VARBYTE (length) data type to preserve the length
Column names with line breaks to preserve the line break in the result transformation

Release 3.0.113 - August 16th, 2022

SnowConvert Core 7.11.91.0

Added:

Add support for returning multiple cursors resultsets
Add double decimal precision for conversion rates on assessment reports
Substitute Label calls with label block statements from BTEQ to SnowScripting

Fixes and improvements:

Parsing Error associated with the line breaks in the quoted column names
View definition is after it uses causing an error due to unwanted topological reordering
DATE cast to VARCHAR FORMAT error

Release 3.0.84 - August 01st, 2022

SnowConvert Core 7.11.22

Added:

Support CEILING, NOW, NVP, TRANSLATE_CHK
Support Calendar functions
Support TO_BYTES function
ERRORCODE and ACTIVITYCOUN mapped to SQLCODE and SQLROWCOUNT from BTEQ to SnowScripting
IF structure from BTEQ to SnowScripting

Fixes and improvements:

Issues.csv has some data with Return characters
Fix EWI inconsistencies in the TopLevelQueries report
Inconsistent hyphens in .docx report

Release 3.0.69 - July 18th, 2022

SnowConvert Core 7.9.154

Added:

St_SphericalDistance function transformation to Haversine
CURDATE function transformation to CURRENT_DATE
INSTR function transformation to REGEXP_INSTR SF function
DAYNUMBER_OF_WEEK function transformation to TD_DAY_OF_WEEK_UDF
WEEKNUMBER_OF_YEAR function transformation to WEEK_OF_YEAR_UDF

Fixes and improvements:

Missing comments for DECLARE variable and LOCK TABLE
UDF Function MONTHS_BETWEEN result has more decimals than Teradata
Reference to calculated column within the same query
Table alias inside UPDATE statement
Continue handler does not comment correctly when facing a parsing error
UDF function FULL_DAY_NAME is not being inserted in the UDF Helpers folder
TD_YEAR_END and TD_YEAR_BEGIN are incorrectly migrated
Update statement is adding the table in the FROM clause
Assessment inconsistencies occurred while migrating DynamicSql statements
Some warnings been reported as MSCEWI2023 while migrating scripts to python

Release 3.0.68 - July 5th, 2022

SnowConvert Core 7.9.98

Fixes and improvements:

Transformation of PROFILE to Snowflake
Support for functions TD_YEAR_END and TD_YEAR_BEGIN
Fix FULL_DAY_NAME UDF not existing

Release 3.0.60 - July 4th, 2022

SnowConvert Core 7.9.83

Added:

Snowflake Script custom errors exception handling

Fixes and improvements:

SYS_CALENDAR.Public.Calendar Table not added
The Quarter of Year function was not supported
The TD_SYSFNLIB.YEARNUMBER_OF_CALENDAR function was not recognized
Fix newly integrated critical exceptions in workloads
Number Alias incorrect
The Next Day function was not recognized

Release 3.0.38 - June 20th, 2022

SnowConvert Core 7.9.30

Added:

Macro returning multiple resultsets
Update logos in UI/Doc/Reports

Fixes and improvements:

Trim for collate columns must add a warning and a possible
Cursor when needing bind variables needs to be migrated with using syntax
Macro Snowscript with CTE does not return the values
SUBSTR function is not recognized

Release 3.0.28 - June 9th, 2022

SnowConvert Core 7.9.1

Added:

Reduce exceptions in current workloads supporting unmanaged cases in some transformations

Fixes and improvements:

A call to a procedure is not being qualified with the PUBLIC schema using Snowflake Scripting
Helper PUBLIC.TIMESTAMP_DIFFERENCE_UDF can not be deployed

Release 3.0.21 - June 7th, 2022

SnowConvert Core 7.3.0

Added:

Consistency in adding 'PUBLIC' to tables in FROM and WHERE clauses
Change EULA file to a new and updated version

Fixes and improvements:

Columns are not being qualified with PUBLIC schema
Incorrect operation between timestamp and INTERVAL
Incorrect conversion of Cast to VARCHAR
Time Zone operation with MAX function is not using the column in the result code
Parsing errors in Stored procedures are causing its content to be outside the procedure
Column name with UESCAPE in a table definition is not being converted
Add_Month Function Fix
Time Zone operation with MAX function is not using the column in the result code
EWI MSCEWI1013 is not shown in the code (conversion of Macro to Procedure)

Release 3.0.6 - May 25th, 2022

SnowConvert Core 7.2.6

Added:

Support for Prepare Statement in Snowflake Scripting

Fixes and improvements:

JSON_TABLE is not working properly transforming the column on select or with a where condition
Conversion to JSON data type is not being converted correctly
Primary Index syntax removed
TIMEZONE_HOUR in EXTRACT causing MSCEWI1001
Minus and Union keyword between parenthesis causing MSCEWI1001
Missing python snippets in the TopLevelQueries report
Fix EWI inconsistencies in the TopLevelObject report

Release 2.0.254 - May 10th, 2022

SnowConvert Core 5.0.133

Added:

Enable Macro generation to Snowflake Scripting
Macro return Select in the converted procedure to Snowflake Scripting
Stored procedures can now return a dynamic table to Snowflake Scripting

Fixes and improvements:

Unclosed Comment Before Loops
Some interval expressions are not being transformed to Snowflake Scripting
TLO reports negative conversion rates
Date functions not converted: td_week_of_year, td_day_of_year, td_day_of_calendar
Skip and Convert keywords on source code causing EWI MSCEWI1001
Cast function to varchar is being replaced by Left in all cases

Release 2.0.229 - April 25th, 2022

SnowConvert Core 5.0.91

Added:

Support of cursor named scope in FOR statement to Snowflake Scripting

Fixes and improvements:

EXECUTE MACRO statement is not converted
OTranslate function is not being converted correctly using Unicode Delimited Character
PARTITION_BY is reported incorrectly when converted to Snowflake Scripting

Release 2.0.213 - April 12th, 2022

SnowConvert Core 5.0.71

Added:

CTE conversion requires ordered subqueries
JSON_TABLE statement from Teradata to split JSON columns is not supported
Escaped commas causing failures in assignments of Snowflake Scripting

Fixes and improvements:

Sync UDF Teradata Helpers
Update DATE_ADD_UDF
Truncation issue with timestamp cast to varchar
UPDATE without FROM clause is not supported
Qualified local variables causing errors in procedures
Corrupted lines (extra CRLF, LF) in CSV files
Empty Statement generating errors in output code
MONTH and YEAR functions are reported as functions not recognized
HTML assessment report is not working

Release 2.0.191 - March 28th, 2022

SnowConvert Core 5.0.35

Added:

Added transformation for TD_UNPIVOT function
EXECUTE statement can use PREPARE statement info

Fixes and improvements:

LOGGING ALL ERRORS is not parsing in INSERT and MERGE statements
CONVERT_TIMEZONE function is removing the column reference
EXPAND ON PERIOD clause causes the source code to be lost
Parsing error of Common Table Expression using RECURSIVE modifier
TRIM function is been reported as an error

Release 2.0.167 - March 14th, 2022

SnowConvert Core 4.0.108

Added:

Added support for OADD_MONTHS function
Added support for TD_DAY_OF_WEEK function
Added binding of local variables and parameters in procedures to Snowflake Scripting

Fixes and improvements:

TLO/TLQ Files - HighestEWISeverity LOW should not affect the conversion rate
TPT files are partially converted
TPT Transform APPLY node
GEO-SPATIAL type is not supported
Fix conversion of expression intervals with literal expressions
DROP STATISTICS statement is causing parsing errors
Translation for negative expression is failing
Sum between Timestamp and time interval is not being converted correctly

Release 2.0.144 - February 28th, 2022

Updated Conversion Core 4.0.60

Added

Added Severity column to the Issues.csv report

Fixed

Assessment CSV output files are now showing parent file relative path
Missing report info for MSCEWI1049 function was not recognized
NOT IN ANY with queries were not translated correctly
MLoad conversion issues were found with where conditions
Top Level Object reported negative conversion rates
Fix conversion errors of LIKE transformation to Snowflake Scripting

Release 2.0.125 - February 14th, 2022

Updated Conversion Core 4.0.33

Added

Support for return values of a procedure to Snowflake Scripting when used OUT or INOUT parameters

Fixed

Standardize signs in Assessment.docx
Missing report info for MSCEWI1031 Function Not Supported
NUMBER default precision - scale changed from (38,19) to (38,18) to decrease inconsistencies in binary operations. Check here for more information
Query result in SF is not the same as TD with Interval operation
NOT IN ANY with a single value list or a multiple value list were not translated correctly