Generated OTHER_UDF.sql helper file has some compilation errors
Duplicated quit_application() statement in BTEQ - Python files
Extra folder created after migration in UNIX OS
Assessment Mode generates not wanted UDF files
Unbound title message in Assessment Mode GUI
[Assessment Report] Add table: "Data Types"
[Assessment Report] Add table: "Data Values"
[Assessment Report] Add table: "Unique Conversion Elements"
Generate stub for XMLAGG function
Conversion for REGEX_REPLACE function
Support helper for DATE conversion with JS EXEC
[TPT] Conversion percentages for most commonly used statements.
Recognize SESSION and use current_session()
New internal documentation to Python helpers, more info here
Exception serializing file in .mobilize/ folder
Transformation for CALL with DBC.SYSEXECSQL()
Several parsing errors on Stored Procedures make the Conversion Rate very low.
LIKE statement is now converted to LIKE statement in SnowFlake
[TPT] Significant reduction of parsing errors in client's workload.
Linux CLI crash.
[Assessment Report] Add table: "Constraint / Data Values" for Assesment.docx report
[Assessment Report] Add table: "Object naming" for Assesment.docx report
[Assessment Report] Add table: "Table Types" for Assesment.docx report
NULLS FIRST to ORDER by ASC when needed.
Identify unsupported usage of INTERVAL constant
Warning message to CREATE [SET] VOLATILE TABLE as SELECT ...
TIMES_DIFFERENCE to TIME_DIFFERENCE
Performance issue, JOIN operator causes throughput degradation.
WITH CHECK OPTION in view definition not supported in SnowFlake
[CodeSmells] Top priority code smells.
[TPT] Transform OPERATOR node for type DDL and UPDATE
[TPT] Transform OPERATOR node for type DATACONNECTOR PRODUCER
Some comments are getting lost during translation
Procedures not identified in TopLevelObject report nor Assessment report
Fix .mload parsing IMPORT WHERE with multiple nested logical comparisons
Control flow on BTEQ scripts translation is not preserving equivalence
NOT expression in LIKE ANY statements
Fixing issue with global variables being defined twice with the Python Helpers new version.
[AssessmentReport] Replace "object ratio" for "file generated ratio" in files table
[AssessmentReport] Removal of "Notes on Output Files Not Generating" from table of content when not needed.
[AssessmentReport] Add SnowConvert and ConversionCore versions to the assessment report and assessment csv.
TIMESTAMP at TIMEZONE conversion
Mapping SUBSTR function to UDF when "startPosition" is zero or negative
Identify Teradata Integer Dates and use UDF
Mapping TO_DATE function to UDF when 'format' is JULIAN (YYYYDDD).
Added conversion rate by SQL Top Level object in Dashboard.csv
Support for MLOAD IMPORT with APPLY using WHERE statements
The next image highlights the differences in the python generated code between versions 1.7.14 and 2.0.0.
The main differences are:
Line 7 on the right, where a new import is made for the "exec" function.
All instances of the string "snowconvert_helpers" are changed to "snowconvert.helpers".
All instances of the "execute_sql_statement" are changed to "exec".
The "exec" function (and other functions) now have the "con" parameter optional. If not passed it will use the last connection.
A "main" function is created instead of having a "try"... "except"... "finally" block, for better code organization.
More info about the changes can be found here.
[Assessment Report] Explanation to tables "SQL/Scripts - Identified Objects".
[Assessment Report] Conditional generation of last's section "Notes on Output Files Not Generating".
Error when loading files due to race conditions in a multithreading environment.
MLOAD migration issues with LAYOUT
Typo in Assessment Report.
Parsing problem with PERIOD and INTERVAL as CASE expressions.
Object Conversion Rate value not associated in Assessment Report.
Initial setup + parsing of TPT files.
Issue that caused integer, decimal and number datatypes to always be converted to float.
Regression, some top-level objects were not identified anymore.
Crash in Linux when two files differ only by capitalization.
MLOAD .LOGOFF statement
MLOAD .END Statement Warning
Fixing an unexpected encoding crash, a new EWI was created to represent this issue (more info here).
[UX] Encoding auto-select issue when changing TimeStampt format.
Crash at Step 3, Semantic Analysis of Top Level Objects.
[BTEQ] Do not introduce unnecessary TRUNC statements if not needed.
Fix parsing of CONTAINS keyword followed by an additive expression.
Table PARTITION BY Statement Issue.
[UX] Encoding auto-select issue.
Transformation for CREATE FUNCTION syntax.
Several Assessment Report Improvements:
Adding count of procedures with IN/OUT or OUT parameters.
Adding count of views that reference more than 10 dependencies.
Adding info about "max() vs (order by) and other non-rank related window functions".
Adding info about "Float Data Aggregation".
Adding info about the "JOIN elimination" feature in Teradata.
Adding info for FUNCTIONs identified on the source code, such as count (detailed by language), conversion rate, lines of code, parsing errors, among others.
INSTR User Defined Function parameters mismatch.
Generation of queries with LOCKING statement inside procedures.
Parsing of CONTAINS keyword followed by an additive expression.
Top-Level Queries report generation, more info here.
Parallel CLI implementation.
Parsing for CREATE FUNCTION syntax.
Fix stub generation Case_N in MAC OS.
Add explicit binding for Date type variables.
Symbol Loading improvements.
Parsing and conversion support for "^" character, which is a "NOT" equivalent.
Support for Command Line Interface (CLI) on Linux Operating System.
Preserving comments in BTEQ files.
Fixed a problem that caused previously activated licenses to be ignored.
The BTEQ files converted to Python scripts now include a comment that indicates the compatible version of the SnowConvert Helpers, so that the person installing the PIP package can install the correct version.
Extra columns to the TopLevelObject CSV report.
Support for HEX_ENCODE function calls.
Support for timestamp difference (minus operator).
Stub files generation improvements.
Better naming conventions for files and elements.
Added PUBLIC Schema for all stub functions.
Stub files are now generated under "UDF Helpers" folder.
[Assessment] Downgrade the dynamic SQL issue from Error to a Warning.
The SnowConvert Python Helpers are now distributed as a Python package.
Random with bounds not converted properly
TRIM function support Collation but errors
LTRIM Collation Compile Issue
Hexadecimal character literals not converted properly
Minor issue in conversion of
Fixed a false positive detection of recursive references in a Forward Alias
Fixes in the snowconvert_helpers Python package
Added hyperlinks for each issue in the issues breakdown summary report
Added support for UNPIVOT statement
Improved EWI classification
Fixed some INTO ? in EXEC statements not being transformed correctly
Fixed issue of Timestamp with default date
[Assessment] Missing dependent object improvements
CREATE TABLE AS ... WITH NO DATA
Support for Teradata timezone change
EXPORT add support for all variants
Binding arguments are not being replaced by ? for
BTEQ error recovery mechanism should consider newlines
CHARACTER is not being mapped to
LEN for all of its variants
Change view reference for DML statements when applicable
Some comments are deleted during migration.
NUMBER conversion require special attention in teradata
.TOISOString from Date Arguments
INT conversion require special attention in Teradata
BTEQ delete all add parameter configuration
If you currently have the
1.5.5 version installed in macOS, you have to uninstall it and install the
1.6.0 version manually.