2023

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

Release 4.1.9 - December 19th, 2023

SnowConvert Core 27.1.20

Fixes and improvements:

• Support DAYOFMONTH function

Release 4.0.350 - December 5th, 2023

SnowConvert Core 27.0.11

Fixes and improvements:

• Fix exception thrown on for loops.

• Fix perfomance issue with nested queries.

Release 4.0.339 - November 22nd, 2023

SnowConvert Core 23.0.6

Fixes and improvements:

• Fix CAST to date with the format specified first not converted correctly

• Fix parsing errors related to data type attributes and range

Release 4.0.339 - November 22nd, 2023

SnowConvert Core 23.0.6

Fixes and improvements:

• Fix CAST to date with the format specified first not converted correctly

• Fix parsing errors related to data type attributes and range

Release 4.0.337 - November 15th, 2023

SnowConvert Core 22.5.27

Fixes and improvements:

• Fix the conversion of CAST inside TRIM and CAST AS TIMESTAMP ignoring the precision

• Fix inconsistencies in the report's Issues Breakdown section

Release 4.0.333 - November 8th, 2023

SnowConvert Core 22.5.10

Fixes and improvements:

• Fix the Symbol table not solving correctly the types when casting

• Fix MSCEWI1095 disappearance when the --renamingFile flag was being used in Linux

• Fix UseCharactersConversionRate and UseLinesOfCodeConversionRate reporting always OFF

• Fix CREATE TABLE with a duplicated UNIQUE INDEX clause

• Fix Comparison Operator NE not migrated to <> Operator

Release 4.0.320 - November 1st, 2023

SnowConvert Core 22.4.17

Fixes and improvements:

• Fix default ordering direction in RANK() function conversion

Release 4.0.317 - October 25th, 2023

SnowConvert Core 22.4.2

Fixes and improvements:

• Fix incorrect NAMED phrase conversion

• Optimize local symbols resolution for query scope

• Improve friendly name for MSCEWI1050 and docx report

Release 4.0.306 - October 18th, 2023

SnowConvert Core 22.3.4

Fixes and improvements:

• Transformation for output parameters with dynamic result sets

• Fix CAST delimiting inside boolean operations

• Fix Parsing Error in CAST of FORMAT DATE

• Commenting the statement HELP STATISTICS

Release 4.0.292 - October 11th, 2023

SnowConvert Core 22.2.137

Fixes and improvements:

• SnowConvert banker's rounding removed as PrPr in reports for Snowflake.

• Fix count of data type attributes inside procedures.

• Improve parsing of TPT's APPLY statement to avoid exceptions

Release 4.0.287 October 4th, 2023

Added:

• Support for WHERE conditions in IMPORT APPLY for MLOAD scripts

Release 4.0.282 - September 27th, 2023

SnowConvert Core 22.2.90

Added:

• SplitPeriodDatatype and DisableTopologicalLevelReorder parameters to Assessment.json report

Fixes and improvements:

• Fix Complex Pattern Issue showing for subqueries related to EXISTS/ NOT EXISTS, SOME

• Fix Complex Pattern Issue showing for subqueries related to IN/NOT IN, ALL/ANY

Release 4.0.278 - September 20th, 2023

SnowConvert Core 22.2.73

Added:

• Report MSCEWI2091 when an ambiguous CAST or FUNCTION call is found

Fixes and improvements:

• Improve the report of MSCEWI1039 with additional information for CREATE TABLE

• Preserve EWIs in subqueries within CREATE VIEW WHERE clauses, ensuring consistent conversion rates.

Release 4.0.277 - September 13th, 2023

SnowConvert Core 22.2.63

Added:

• Add an option to disable the topological level reorder. For more information, review the following documentation.

• Fix the reordering code option when it is not required

Fixes and improvements:

• Improve the process translation for conditional operations that use implicit CAST statements

• Fix return statement that is transformed in order to support output parameters with original and equivalent values

Release 4.0.266 - September 7th, 2023

SnowConvert Core 22.2.48

Added:

• Support WITH DEFAULT clause in columns

Fixes and improvements:

• Fix SQLCODE initialization

Release 4.0.259 - August 30th, 2023

SnowConvert Core 22.2.30

Added:

• Implement Case-Insensitive Validation for Table Aliases on Update Statements

• Support DECLARE CURSORS defined with CTE

Fixes and improvements:

• Fix conversion exception while transforming CURRENT_TIME function cast to TIME

Release 4.0.253 - August 23rd, 2023

SnowConvert Core 22.2.9

Added:

• Support Reset When node when a conditional window function is a column

Fixes and improvements:

• Improve transformation binary operations with Intervals

Release 4.0.241 - August 16th, 2023

SnowConvert Core 22.0.47

Added:

• Generate new Elements csv report for conversions and assessments

Fixes and improvements:

• Fix different DML LABEL statements output order

• Parse DISABLE as an identifier

• Comment out CREATE INDEX statement

• Fix stack overflow being thrown in postfix expression

• Fix exception thrown when converting UPDATE with string types and PIVOT without column name

Release 4.0.232 - August 3rd, 2023

SnowConvert Core 22.0.17

Fixes and improvements:

• Improve EWI mechanism for better consistency

Release 4.0.226 - July 28th, 2023

SnowConvert Core 21.0.165

Fixes and improvements:

• Correcting license registration in CLI executable

Release 4.0.222 - July 26th, 2023

SnowConvert Core 21.0.165

Added:

• Add transformation to Python for the BTEQ REPEAT statement

Release 4.0.219 - July 19th, 2023

SnowConvert Core 21.0.153

Added:

• Generate new Object References csv report for conversions and assessments

• Generate new Missing Object References csv report for conversions and assessments

• Add support for the USING REQUEST MODIFIER Bteq special syntax

• Transformation for USING in INSERT/UPDATE/DELETE/SELECT queries for Bteq

Fixes and improvements:

• Adding new columns and reordering existing columns on the Issues.csv report

• Remove generation of HtmlReport for all conversions and assessments

• Parse SAVEPOINT as an identifier

• Include conversion settings in the Assessment Report to view the selected conversion language such as JavaScript and Snowflake Scripting

• Triggers represented as Top Level Objects in the Assessment Report

• Improve exception handling

Release 4.0.194 - July 5th, 2023

SnowConvert Core 21.0.107

Fixes and improvements:

• Parse SAVEPOINT as an identifier

• Include conversion settings in the Assessment Report to view the selected conversion language such as JavaScript and Snowflake Scripting

• Triggers represented as Top Level Objects in the Assessment Report

• Improve exception handling

Release 4.0.183 - June 29th, 2023

SnowConvert Core 21.0.93

Fixes and improvements:

• Update the license mechanism to a more secure compliant mechanism

• Count of join indexes that reference multiple objects added to the assessment report

• Support IMPORT, LAYOUT, and DML LABEL in MLOAD to Snowflake Scripting

• Support Upsert labels in MLOAD to Snowflake Scripting

• Support for NullExpr conditions in MLOAD fields converted to Python

• Fixed script conversion rate accuracy with script breakdown

• Fixed name column being changed in subquery with a similar name as an alias in the parent query

• Fixed parsing error on SEL INTO statement where the variable has a ":"

Release 4.0.133 - June 14th, 2023

SnowConvert Core 21.0.52

Fixes and improvements:

• DML LABEL was being transformed differently on Mac and Windows

• Support for output parameters in Teradata Procedures

• Modify mechanism to upload SQL SnowConvert assessment metadata

Release 4.0.123 - June 8th, 2023

SnowConvert Core 21.0.43

Fixes and improvements:

• The correct conversion rate of tables with low EWIs present

• The object conversion rate in tables is not 100% with only low EWIs present

• The object conversion rate in procedures is 100% when MSCCP0001 is present

• The object conversion rate in procedures is not 100% when no EWIs present

• The object conversion rate in procedures is not 100% with only low EWIs present

• The object conversion rate in views is not 100% with only low EWIs present

• EWIs inconsistency in views

• Partial support for EXPORT OUTFILE statement

• Comparisons for strings columns with trailing spaces to have the same behavior as the original code. RTRIM function added to ignore trailing spaces.

• The LOC conversion rate for Join Indexes when found inside a top-level object

• Shell variables in Python scripts

Release 4.0.104 - May 24th, 2023

SnowConvert Core 20.4.20

Added:

• Update UI and CLI BteqTargetLanguage conversion parameters to include MLOAD

• Support BEGIN LOADING for FLOAD to Python

• Support DEFINE COLUMN for FLOAD to Python

• Support SET RECORD for FLOAD to Python

Fixes and improvements:

• Fix the wrong LOC Conversion Summary value shown in the UI summary window

• Fix EWIs inconsistency in Tables

• Fix parsing errors caused by precedence

• Fix parsing error caused by CALLED identifier

Release 4.0.99 - May 10th, 2023

SnowConvert Core 20.2.8

Added: