2022
Details about the releases of Snowflake SnowConvert for Teradata during 2022.
Last updated
Details about the releases of Snowflake SnowConvert for Teradata during 2022.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
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
SnowConvert Core 13.0.16
Added:
Support NORMALIZE clause
Fixes and improvements:
Duplicated schema added inside execute immediate in scripts
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
SnowConvert Core 11.0.108
Added:
Support Main Log Table (DBQLogTbl) and its columns StartTime and FirstStepTime
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
SnowConvert Core 11.0.28
Added:
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
SnowConvert Core 10.0.0
Fixes and improvements:
Line breaks not been preserved inside embedded code as string resulting in execution errors.
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
SnowConvert Core 9.2.23.0
Fixes and improvements:
Date column plus cast to interval value, the Snowflake translation now uses DATEADD function instead
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
SnowConvert Core 9.0.69
Support LAST function for period data type
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
SnowConvert Core 9.0.48
Fixed bug that causes UI to not display the text in certain windows
SnowConvert Core 9.0.37
Provide decimals to conversion rate values in TopLevelObjects and TopLevelQueries reports
Support BEGIN TRANSACTION in LOCKING Request Modifier as part of the SQL Request
Column name being changed when inside a subquery
SnowConvert Core 7.11.119.0
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
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
SnowConvert Core 7.11.91.0
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
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
SnowConvert Core 7.11.22
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
Issues.csv has some data with Return characters
Fix EWI inconsistencies in the TopLevelQueries report
Inconsistent hyphens in .docx report
SnowConvert Core 7.9.154
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
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
Transformation of PROFILE to Snowflake
Support for functions TD_YEAR_END and TD_YEAR_BEGIN
Fix FULL_DAY_NAME UDF not existing
Snowflake Script custom errors exception handling
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
Macro returning multiple resultsets
Update logos in UI/Doc/Reports
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
Reduce exceptions in current workloads supporting unmanaged cases in some transformations
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
Consistency in adding 'PUBLIC' to tables in FROM and WHERE clauses
Change EULA file to a new and updated version
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)
Support for Prepare Statement in Snowflake Scripting
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
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
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
Support of cursor named scope in FOR statement to Snowflake Scripting
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
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
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
Added transformation for TD_UNPIVOT function
EXECUTE statement can use PREPARE statement info
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
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
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
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
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
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
Updated Conversion Core 3.2.86
Added
Support for generating Snowflake Scripting for procedural code
Support for SET TIME ZONE query
Fixed
Cast as varchar(19) on date operation is causing a truncation issue
The trailing function is not being converted correctly
Interval operation with timestamps is not being converted correctly
Replace statement LEAVE by the statement BREAK in Snowflake Scripting
Remove label name information of outer procedure blocks in Snowflake Scripting
Updated Conversion Core 3.2.67
Added
Conversion of NEW JSON
Conversion of REGEXP_SIMILAR
Fixed
SqlCode, SqlState and Activity_Count capitalization
Like Any Syntax when collation
Updated Conversion Core 3.2.24
Fixed
Alter Table .. Drop column_name not supported
Support Expand On clause for it uses
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
Added new code arrange functionality to prepare the code before the migration, for an in-depth explanation visit the
Comment the uses of as it is not supported at this time
NUMBER default precision - scale changed from (38,19) to (38,18) to decrease inconsistencies in binary operations.
