LogoLogo
SnowflakeDocumentation Home
  • Snowflake SnowConvert Documentation
  • General (Beta)
    • Getting Started
      • System Requirements
      • Download and Access
      • Best practices
      • End User License Agreement
      • Release Notes ( Beta)
    • General Issues and Troubleshooting
      • FAQ and Troubleshooting
      • Complex Pattern Issues
        • MSCCP0001
        • MSCCP0002
        • MSCCP0003
        • MSCCP0004
        • MSCCP0005
        • MSCCP0006
        • MSCCP0007
        • MSCCP0008
        • MSCCP0009
        • MSCCP0010
        • MSCCP0011
      • Conversion Issues
        • MSCEWI1001
        • MSCEWI1002
        • MSCEWI1003
        • MSCEWI1004
        • MSCEWI1005
        • MSCEWI1006
        • MSCEWI1007
        • MSCEWI1009
        • MSCEWI1010
        • MSCEWI1011
        • MSCEWI1012
        • MSCEWI1013
        • MSCEWI1014
        • MSCEWI1015
        • MSCEWI1016
        • MSCEWI1017
        • MSCEWI1018
        • MSCEWI1019
        • MSCEWI1020
        • MSCEWI1021
        • MSCEWI1022
        • MSCEWI1023
        • MSCEWI1024
        • MSCEWI1025
        • MSCEWI1026
        • MSCEWI1027
        • MSCEWI1028
        • MSCEWI1029
        • MSCEWI1030
        • MSCEWI1031
        • MSCEWI1032
        • MSCEWI1033
        • MSCEWI1034
        • MSCEWI1035
        • MSCEWI1036
        • MSCEWI1037
        • MSCEWI1038
        • MSCEWI1039
        • MSCEWI1040
        • MSCEWI1041
        • MSCEWI1042
        • MSCEWI1043
        • MSCEWI1044
        • MSCEWI1045
        • MSCEWI1046
        • MSCEWI1047
        • MSCEWI1048
        • MSCEWI1049
        • MSCEWI1050
        • MSCEWI1051
        • MSCEWI1052
        • MSCEWI1053
        • MSCEWI1054
        • MSCEWI1055
        • MSCEWI1056
        • MSCEWI1057
        • MSCEWI1058
          • Teradata
          • Oracle
          • SQL Server
        • MSCEWI1059
        • MSCEWI1060
        • MSCEWI1061
        • MSCEWI1062
        • MSCEWI1063
        • MSCEWI1064
        • MSCEWI1065
        • MSCEWI1066
        • MSCEWI1067
        • MSCEWI1068
        • MSCEWI1069
        • MSCEWI1070
        • MSCEWI1071
        • MSCEWI1072
        • MSCEWI1073
        • MSCEWI1074
        • MSCEWI1075
        • MSCEWI1076
        • MSCEWI1077
        • MSCEWI1078
        • MSCEWI1079
        • MSCEWI1080
        • MSCEWI1081
        • MSCEWI1082
        • MSCEWI1083
        • MSCEWI1084
        • MSCEWI1086
        • MSCEWI1087
        • MSCEWI1088
        • MSCEWI1089
        • MSCEWI1090
        • MSCEWI1091
        • MSCEWI1092
        • MSCEWI1093
        • MSCEWI1094
        • MSCEWI1095
        • MSCEWI1096
        • MSCEWI1097
        • MSCEWI1098
        • MSCEWI1099
        • MSCEWI1100
        • MSCEWI1101
        • MSCEWI1102
        • MSCEWI1108
      • Informative Issues
        • MSCINF0001
        • MSCINF0002
        • MSCINF0003
        • MSCINF0004
        • MSCINF0005
        • MSCINF0006
        • MSCINF0007
        • MSCINF0008
    • Review Results
      • Output Code
      • Reports
        • Assessment Report
          • Overall Conversion Summary
          • SQL Conversion Summary
          • Scripts Line Conversion Summary
          • Object Conversion Summary
          • File and Object Level Breakdown - SQL Files
          • File and Object Level Breakdown - SQL Identified Objects
          • Scripts - Files
          • Scripts - Identified Objects
          • Schemas
          • Databases & Schemas
        • Top-Level Objects Report
        • Top-Level Queries Report
        • Issues Report
        • HTML Report
        • Missing Objects Report
        • Object References Report
        • Elements Report
    • How to Use SnowConvert with Docker
  • User Guide (Beta)
    • User Guide
    • How to install the tool
      • Linux
      • Windows
      • MacOS
    • How to update the tool
    • How to request an access code
    • What is a SnowConvert Project?
    • Supported Source Platforms
    • Assessment
      • Analyzing subfolders
    • Conversion
      • Converting subfolders
      • General Conversion Settings
      • Teradata Conversion Settings
      • Oracle Conversion Settings
      • SQL Server Conversion Settings
    • How to use the SnowConvert CLI
    • Additional Parameters
      • SnowConvert for SQL
      • Spark SnowConvert
    • Command Line Interface
  • FOR SQL LANGUAGES (BETA)
    • Release Notes
      • 2024
      • 2023
    • General Issues and Troubleshooting
  • General (Legacy)
    • Getting Started
      • Download and Access
      • Installation and Licensing
      • End User License Agreement
    • Contact Us
  • Function Reference
    • Teradata
      • CHAR2HEXINT_UDF
      • CHCKNUM_UDF
      • DATEADD_UDF
      • TIMESTAMP_DIFFERENCE_UDF
      • EXTRACT_TIMESTAMP_DIFFERENCE_UDF
      • TIME_DIFFERENCE_UDF
      • DATE_TO_INT_UDF
      • INT_TO_DATE_UDF
      • FIRST_DAY_OF_MONTH_ISO_UDF
      • DAYNUMBER_OF_MONTH_UDF
      • DAYNUMBER_OF_YEAR_UDF
      • COMPUTE_EXPAND_ON_UDF
      • EXPAND_ON_UDF
      • DIFFTTIME_PERIOD_UDF
      • ROW_COUNT_UDF
      • GETQUERYBANDVALUE_UDF
      • GETQUERYBANDVALUE_UDF
      • INSTR_UDF
      • INSTR_UDF
      • INSTR_UDF
      • INTERVAL_MULTIPLY_UDF
      • INTERVAL_ADD_UDF
      • INTERVAL_TO_MONTHS_UDF
      • INTERVAL_TO_SECONDS_UDF
      • JSON_EXTRACT_DOT_NOTATION_UDF
      • JSON_EXTRACT_UDF
      • JULIAN_TO_DATE_UDF
      • MONTHS_BETWEEN_UDF
      • NULLIFZERO_UDF
      • NVP_UDF
      • PERIOD_INTERSECT_UDF
      • PERIOD_OVERLAPS_UDF
      • QUARTERNUMBER_OF_YEAR_UDF
      • ROUND_DATE_UDF
      • SUBSTR_UDF
      • SUBSTR_UDF
      • TD_DAY_OF_CALENDAR_UDF
      • TD_DAY_OF_WEEK_UDF
      • TD_DAY_OF_WEEK_COMPATIBLE_UDF
      • TD_WEEK_OF_YEAR_UDF
      • TD_DAY_OF_WEEK_COMPATIBLE_UDF
      • FIRST_DAY_JANUARY_OF_ISO_UDF
      • YEAR_BEGIN_ISO_UDF
      • TD_YEAR_BEGIN_UDF
      • LAST_DAY_DECEMBER_OF_ISO_UDF
      • YEAR_END_ISO_UDF
      • TD_YEAR_END_UDF
      • TIMESTAMP_ADD_UDF
      • DAY_OF_WEEK_LONG_UDF
      • MONTH_NAME_LONG_UDF
      • TO_BYTES_HEX_UDF
      • CENTURY_UDF
      • DAYNAME_LONG_UDF
      • DAYNAME_LONG_UDF
      • DATE_LONG_UDF
      • FULL_MONTH_NAME_UDF
      • ISO_YEAR_PART_UDF
      • JULIAN_DAY_UDF
      • MONTH_SHORT_UDF
      • ROMAN_NUMERALS_MONTH_UDF
      • SECONDS_PAST_MIDNIGHT_UDF
      • WEEK_OF_MONTH_UDF
      • YEAR_PART_UDF
      • YEAR_WITH_COMMA_UDF
      • INSERT_CURRENCY_UDF
      • WRAP_NEGATIVE_WITH_ANGLE_BRACKETS_UDF
      • TRANSLATE_CHK_UDF
      • WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
      • WEEK_NUMBER_OF_QUARTER_ISO_UDF
      • WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
      • WEEKNUMBER_OF_MONTH_UDF
  • For Teradata
    • Introduction
    • Getting Started (LEGACY)
      • Training and Support
      • Code Extraction
      • Using SnowConvert
      • Review Results
        • Assessment.csv Report
        • Assessment.docx Report
        • Elements Report
        • Issues Report
        • Lineage Report
        • Output code
        • TopLevelObjects Report
    • Command Line Interface
      • Renaming feature
    • Code Extraction
    • Processing the code
      • Preprocess tasks
    • SQL Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI2001
      • MSCEWI2002
      • MSCEWI2003
      • MSCEWI2004
      • MSCEWI2005
      • MSCEWI2006
      • MSCEWI2007
      • MSCEWI2008
      • MSCEWI2009
      • MSCEWI2010
      • MSCEWI2011
      • MSCEWI2012
      • MSCEWI2013
      • MSCEWI2014
      • MSCEWI2015
      • MSCEWI2016
      • MSCEWI2017
      • MSCEWI2018
      • MSCEWI2019
      • MSCEWI2020
      • MSCEWI2021
      • MSCEWI2022
      • MSCEWI2023
      • MSCEWI2024
      • MSCEWI2025
      • MSCEWI2026
      • MSCEWI2027
      • MSCEWI2028
      • MSCEWI2029
      • MSCEWI2030
      • MSCEWI2031
      • MSCEWI2032
      • MSCEWI2033
      • MSCEWI2034
      • MSCEWI2035
      • MSCEWI2036
      • MSCEWI2037
      • MSCEWI2038
      • MSCEWI2039
      • MSCEWI2040
      • MSCEWI2041
      • MSCEWI2042
      • MSCEWI2043
      • MSCEWI2044
      • MSCEWI2045
      • MSCEWI2046
      • MSCEWI2047
      • MSCEWI2049
      • MSCEWI2050
      • MSCEWI2051
      • MSCEWI2052
      • MSCEWI2053
      • MSCEWI2054
      • MSCEWI2055
      • MSCEWI2056
      • MSCEWI2057
      • MSCEWI2058
      • MSCEWI2059
      • MSCEWI2060
      • MSCEWI2061
      • MSCEWI2062
      • MSCEWI2063
      • MSCEWI2064
      • MSCEWI2065
      • MSCEWI2066
      • MSCEWI2067
      • MSCEWI2068
      • MSCEWI2069
      • MSCEWI2070
      • MSCEWI2071
      • MSCEWI2072
      • MSCEWI2073
      • MSCEWI2074
      • MSCEWI2075
      • MSCEWI2076
      • MSCEWI2077
      • MSCEWI2078
      • MSCEWI2079
      • MSCEWI2080
      • MSCEWI2081
      • MSCEWI2082
      • MSCEWI2083
      • MSCEWI2084
      • MSCEWI2085
      • MSCEWI2086
      • MSCEWI2087
      • MSCEWI2088
      • MSCEWI2089
      • MSCEWI2090
      • MSCEWI2091
    • Release Notes
      • 2024
      • 2023
      • 2022
      • 2021
      • 2020
      • Roadmap
    • Considerations
  • For Oracle
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output Code
        • Assessment Report
        • Issues Report
        • Top-Level Objects Report
    • Command Line Interface
    • Code Extraction
    • Processing the code
      • Preprocess tasks
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI3001
      • MSCEWI3002
      • MSCEWI3003
      • MSCEWI3004
      • MSCEWI3005
      • MSCEWI3006
      • MSCEWI3007
      • MSCEWI3008
      • MSCEWI3009
      • MSCEWI3010
      • MSCEWI3011
      • MSCEWI3012
      • MSCEWI3013
      • MSCEWI3014
      • MSCEWI3015
      • MSCEWI3016
      • MSCEWI3017
      • MSCEWI3018
      • MSCEWI3019
      • MSCEWI3020
      • MSCEWI3021
      • MSCEWI3022
      • MSCEWI3023
      • MSCEWI3024
      • MSCEWI3025
      • MSCEWI3026
      • MSCEWI3027
      • MSCEWI3028
      • MSCEWI3029
      • MSCEWI3030
      • MSCEWI3031
      • MSCEWI3032
      • MSCEWI3033
      • MSCEWI3034
      • MSCEWI3035
      • MSCEWI3036
      • MSCEWI3037
      • MSCEWI3038
      • MSCEWI3039
      • MSCEWI3040
      • MSCEWI3041
      • MSCEWI3042
      • MSCEWI3043
      • MSCEWI3044
      • MSCEWI3046
      • MSCEWI3047
      • MSCEWI3048
      • MSCEWI3049
      • MSCEWI3050
      • MSCEWI3051
      • MSCEWI3052
      • MSCEWI3053
      • MSCEWI3054
      • MSCEWI3055
      • MSCEWI3056
      • MSCEWI3057
      • MSCEWI3058
      • MSCEWI3059
      • MSCEWI3060
      • MSCEWI3061
      • MSCEWI3062
      • MSCEWI3063
      • MSCEWI3064
      • MSCEWI3065
      • MSCEWI3066
      • MSCEWI3067
      • MSCEWI3068
      • MSCEWI3069
      • MSCEWI3070
      • MSCEWI3071
      • MSCEWI3072
      • MSCEWI3073
      • MSCEWI3074
      • MSCEWI3075
      • MSCEWI3076
      • MSCEWI3077
      • MSCEWI3078
      • MSCEWI3079
      • MSCEWI3080
      • MSCEWI3081
      • MSCEWI3082
      • MSCEWI3083
      • MSCEWI3084
      • MSCEWI3085
      • MSCEWI3086
      • MSCEWI3087
      • MSCEWI3088
      • MSCEWI3089
      • MSCEWI3090
      • MSCEWI3091
      • MSCEWI3092
      • MSCEWI3093
      • MSCEWI3094
      • MSCEWI3095
      • MSCEWI3096
      • MSCEWI3097
      • MSCEWI3098
      • MSCEWI3099
      • MSCEWI3100
      • MSCEWI3101
      • MSCEWI3102
      • MSCEWI3103
      • MSCEWI3104
      • MSCEWI3105
      • MSCEWI3106
      • MSCEWI3107
      • MSCEWI3108
      • MSCEWI3109
      • MSCEWI3110
      • MSCEWI3111
      • MSCEWI3112
      • MSCEWI3113
      • MSCEWI3114
      • MSCEWI3115
      • MSCEWI3116
      • MSCEWI3117
      • MSCEWI3118
      • MSCEWI3119
      • MSCEWI3120
      • MSCEWI3121
      • MSCEWI3122
      • MSCEWI3123
      • MSCEWI3124
      • MSCEWI3125
      • MSCEWI3126
      • MSCEWI3127
      • MSCEWI3128
      • MSCEWI3129
      • MSCEWI3130
      • MSCEWI3131
      • MSCEWI3132
      • MSCEWI3133
      • MSCEWI3135
    • Release Notes
      • 2023
      • 2022
      • 2021
      • 2020
      • Roadmap
    • SQL Translation Reference
  • FOR SQL SERVER
    • Introduction
    • Getting Started (LEGACY)
      • Training and Support
      • Arrange the Source Code
      • Review Results
        • Output Code
        • Assessment Report
        • Issues Report
        • TopLevelObjects Report
      • Using SnowConvert
    • Command Line Interface
    • Code Extraction
    • Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI4001
      • MSCEWI4002
      • MSCEWI4003
      • MSCEWI4004
      • MSCEWI4005
      • MSCEWI4006
      • MSCEWI4007
      • MSCEWI4008
      • MSCEWI4009
      • MSCEWI4010
      • MSCEWI4011
      • MSCEWI4012
      • MSCEWI4013
      • MSCEWI4014
      • MSCEWI4015
      • MSCEWI4016
      • MSCEWI4017
      • MSCEWI4018
      • MSCEWI4019
      • MSCEWI4020
      • MSCEWI4021
      • MSCEWI4022
      • MSCEWI4023
      • MSCEWI4024
      • MSCEWI4025
      • MSCEWI4026
      • MSCEWI4027
      • MSCEWI4028
      • MSCEWI4029
      • MSCEWI4030
      • MSCEWI4031
      • MSCEWI4032
      • MSCEWI4033
      • MSCEWI4034
      • MSCEWI4035
      • MSCEWI4036
      • MSCEWI4037
      • MSCEWI4038
      • MSCEWI4039
      • MSCEWI4040
      • MSCEWI4041
      • MSCEWI4042
      • MSCEWI4043
      • MSCEWI4044
      • MSCEWI4045
      • MSCEWI4046
      • MSCEWI4047
      • MSCEWI4048
      • MSCEWI4049
      • MSCEWI4050
      • MSCEWI4051
      • MSCEWI4052
      • MSCEWI4053
      • MSCEWI4054
      • MSCEWI4055
      • MSCEWI4056
      • MSCEWI4057
      • MSCEWI4058
      • MSCEWI4059
      • MSCEWI4060
      • MSCEWI4061
      • MSCEWI4062
      • MSCEWI4063
      • MSCEWI4064
      • MSCEWI4065
      • MSCEWI4066
      • MSCEWI4067
      • MSCEWI4068
      • MSCEWI4069
      • MSCEWI4070
      • MSCEWI4071
      • MSCEWI4072
      • MSCEWI4073
      • MSCEWI4074
      • MSCEWI4075
    • Release Notes
      • 2023
      • 2022
      • 2021
      • Roadmap
  • For IBM DB2
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSCEWI5001
      • MSCEWI5002
      • MSCEWI5003
      • MSCEWI5004
      • MSCEWI5005
      • MSCEWI5006
      • MSCEWI5007
      • MSCEWI5008
      • MSCEWI5009
      • MSCEWI5010
      • MSCEWI5011
      • MSCEWI5012
      • MSCEWI5013
      • MSCEWI5014
      • MSCEWI5015
      • MSCEWI5016
      • MSCEWI5017
      • MSCEWI5018
      • MSCEWI5019
      • MSCEWI5020
      • MSCEWI5021
      • MSCEWI5022
    • Release Notes
      • 2022
  • For PostgreSQL
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-PG0000
      • MSC-PG0001
      • MSC-PG0002
      • MSC-PG0003
      • MSC-PG0004
      • MSC-PG0005
      • MSC-PG0006
      • MSC-PG0007
      • MSC-PG0008
      • MSC-PG0009
      • MSC-PG0010
      • MSC-PG0011
      • MSC-PG0012
      • MSC-PG0013
      • MSC-PG0014
      • MSC-PG0015
      • MSC-PG0016
      • MSC-PG0017
      • MSC-PG0018
      • MSC-PG0019
      • MSC-PG0020
      • MSC-PG0021
      • MSC-PG0022
      • MSC-PG0023
      • MSC-PG0024
      • MSC-PG0025
      • MSC-PG0026
      • MSC-PG0027
      • MSC-PG0028
    • Release Notes
      • 2022
  • For Greenplum
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-GP0000
      • MSC-GP0001
      • MSC-GP0002
      • MSC-GP0003
    • Release Notes
      • 2022
  • For Amazon RedShift
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-RS0004
      • MSC-RS0005
      • MSC-RS0011
      • MSC-RS0012
      • MSC-RS0013
      • MSC-RS0014
    • Release Notes
      • 2022
  • For Google BigQuery
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSC-BQ0001
      • MSC-BQ0002
      • MSC-BQ0003
      • MSC-BQ0004
      • MSC-BQ0005
      • MSC-BQ0006
      • MSC-BQ0007
      • MSC-BQ0008
      • MSC-BQ0009
      • MSC-BQ0010
      • MSC-BQ0011
      • MSC-BQ0012
      • MSC-BQ0013
      • MSC-BQ0014
      • MSC-BQ0015
      • MSC-BQ0016
    • Release Notes
      • 2022
  • For Apache Hive
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
    • Release Notes
      • 2022
  • For Vertica
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
    • Release Notes
      • 2022
  • for Spark (Scala)
    • Snowpark Migration Accelerator for Spark Scala
  • FOR SPARK (PYTHON)
    • Snowpark Migration Accelerator for PySpark
  • Databricks workloads
    • Getting started
      • DBC files explode
Powered by GitBook
On this page
  • Release 2.0.23 - December 21st, 2021
  • Release 2.0.22 - December 7th, 2021
  • Release 2.0.21 - November 22nd, 2021
  • Release 2.0.20 - November 8th, 2021
  • Release 2.0.19 - October 25th, 2021
  • Release 2.0.18 - October 11th, 2021
  • Release 2.0.17 - September 27th, 2021
  • Release 2.0.16 - September 14th, 2021
  • Release 2.0.15 - September 1st, 2021
  • Release 2.0.14 - August 18th, 2021
  • Release 2.0.13 - August 16th, 2021
  • Release 2.0.11 - August 4th, 2021
  • Release 2.0.10 - July 19th, 2021
  • Release 2.0.9 - July 7th, 2021
  • Release 2.0.8 - July 6th, 2021
  • Release 2.0.7 - June 21st, 2021
  • Release 2.0.6 - June 9, 2021
  • Release 2.0.5 - June 7, 2021
  • Release 2.0.3
  • Release 2.0.0
  • Release 1.7.14
  • Release 1.7.13
  • Release 1.7.11
  • Release 1.7.8
  • Release 1.7.7
  • Release 1.7.5
  • Release 1.7.3
  • Release 1.7.1
  • Release 1.7.0
  • Release 1.6.3
  • Release 1.6.2
  • Release 1.6.1
  1. For Teradata
  2. Release Notes

2021

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

Previous2022Next2020

Last updated 1 year ago

This is a deprecated version of the SnowConvert documentation, please visit the official site .

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

  • 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

  • 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.

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

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

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

  • Stored Procedures don't handle NOT FOUND exception properly

Added

  • Transformation for CREATE TABLE AS

  • Internet connection validation for telemetry

Release 2.0.8 - July 6th, 2021

Updated Conversion Core 3.0.15

Fixed

  • JIS_COLL parsing error

  • SHOW parsing error

  • PERIOD FIELD conversion when a FORMAT or TITLE are attached

  • Functions converting to variables

Added

  • Support to recognize Collation Constraints

  • [TPT] Transform STEP node

  • JSON return object for Store Procedures OUT parameters

  • Conversion for SHOW statement to GET_DDL

  • Support for "--param" to set the LOG_ON environment variables

Release 2.0.7 - June 21st, 2021

Updated Conversion Core to 3.0.12

Fixed

  • Naming inconsistency for UDFs inserted by the Conversion Tool

  • Parsing error in MLOAD import

  • Parsing error of "Last valid token was 'field'}"

  • Export.Reset() exception in BTEQ - Python files

  • "free" command issue

  • MAC OS Big Sur issue that prevented SnowConvert from executing

Added

  • [Assessment Report] Count of views created by "select * from..."

  • Support for TRIM with CAST integer FORMAT '99'

  • Add warnings for unsupported functions

Release 2.0.6 - June 9, 2021

Updated Conversion Core to 3.0.11

Fixed

  • 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

Release 2.0.5 - June 7, 2021

Updated Conversion Core to 3.0.8

Added

  • [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()

Fixed

  • Exception serializing file in temporary 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 the client's workload.

  • Linux CLI crash.

Release 2.0.3

Updated Conversion Core to 3.0.7

Added

  • [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 ...

Fixed

  • DATE variable comparison in Javascript Snow Procedures.

  • Rename UDF 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

Release 2.0.0

This version has breaking changes due to improvements in the SnowConvert Python Helpers

Updated Conversion Core to 3.0.0

Fixed

  • 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.

Added

  • [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

New Python SnowConvert Helpers Version 2.0.0

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.

Have Python code generated with an older version of SnowConvert and wish to use the new version of the helpers?

Here is what you need to do with the code:

  • Add this new import to your files "from snowconvert.helpers import exec".

  • Replace all string instances of "snowconvert_helpers" to "snowconvert.helpers".

  • Replace all string instances of "execute_sql_statement" to "exec".

Release 1.7.14

Updated Conversion Core to 2.0.7

Added

  • [Assessment Report] Explanation to tables "SQL/Scripts - Identified Objects".

  • [Assessment Report] Conditional generation of last's section "Notes on Output Files Not Generating".

Fixed

  • 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.

Release 1.7.13

Updated Conversion Core to 2.0.6

Added

  • Initial setup + parsing of TPT files.

Fixed

  • Issue that caused integer, decimal and number datatypes to always be converted to float.

  • Regression, some top-level objects were not identified anymore.

Release 1.7.11

Updated Conversion Core to 2.0.4

Fixed

  • Crash in Linux when two files differ only by capitalization.

  • MLOAD .LOGOFF statement

  • MLOAD .END Statement Warning

  • [UX] Encoding auto-select issue when changing TimeStampt format.

Release 1.7.8

Updated Conversion Core to 2.0.2

Fixed

  • 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.

Release 1.7.7

Updated Conversion Core to 2.0.0

Added

  • 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.

Fixed

  • INSTR User Defined Function parameters mismatch.

  • Generation of queries with LOCKING statement inside procedures.

  • Parsing of CONTAINS keyword followed by an additive expression.

Release 1.7.5

Updated Conversion Core to 1.11.0

Added

  • Parallel CLI implementation.

  • Parsing for CREATE FUNCTION syntax.

Fixed

  • Fix stub generation Case_N in MAC OS.

  • Add explicit binding for Date type variables.

  • Symbol Loading improvements.

Release 1.7.3

Updated Conversion Core to 1.10.2

Added

  • Parsing and conversion support for "^" character, which is a "NOT" equivalent.

  • Support for Command Line Interface (CLI) on Linux Operating System.

Fixed

  • Preserving comments in BTEQ files.

Release 1.7.1

Fixed

  • Fixed a problem that caused previously activated licenses to be ignored.

Release 1.7.0

Due to an update in the licensing infrastructure, a license key re-activation might be required. This was fixed in the release 1.7.1

Updated Conversion Core to 1.10.0

Added

  • 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).

Fixed

  • 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.

Release 1.6.3

Starting from this release, the SnowConvert Python Helpers will be distributed as a Python Package and will not be copied to the output folder. You can follow the instructions in this documentation page.

Conversion Core 1.9.9

Added

Fixed

  • 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 PIVOT statement

  • Fixed a false positive detection of recursive references in a Forward Alias

  • Fixes in the snowconvert_helpers Python package

Release 1.6.2

Conversion Core 1.9.7

Added

  • Added hyperlinks for each issue in the issues breakdown summary report

  • Added support for UNPIVOT statement

Fixed

  • Improved EWI classification

  • Fixed some INTO ? in EXEC statements not being transformed correctly

  • Fixed issue of Timestamp with default date

Release 1.6.1

Conversion Core 1.9.6

Added

  • [Assessment] Missing dependent object improvements

  • Support for CREATE TABLE AS ... WITH NO DATA

  • Support for Teradata timezone change

  • EXPORT add support for all variants

Fixed

  • Binding arguments are not being replaced by ? for EXEC calls

  • 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.

  • TIME to INT or NUMBER conversion require special attention in teradata

  • Remove .TOISOString from Date Arguments

  • DATE to INT conversion require special attention in Teradata

  • BTEQ delete all add parameter configuration

Known Issues

  • 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.

Improvements to preprocessing scripts, more info

Python helpers technical

Python helpers logging improvements described

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

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

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

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

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

Stored-Procedure-Tags feature, to recognize each converted component, for more information about how to use it in the UI check or in the CLI check .

DBC.COLUMNSV is mapped to INFORMATION_SCHEMA.COLUMNS. More info .

New documentation about Javascript helper functions

New internal documentation to Python helpers, more info

More info about the changes can be found .

Fixing an unexpected encoding crash, a new EWI was created to represent this issue (more info ).

Feature to disable EWI comments generation on transformed code (Errors, Warnings, and Issues), this new option is available in both CLI (more info ) and UI (more info ).

Top-Level Queries report generation, more info .

The SnowConvert Python Helpers are now distributed as a .

HERE
here
documentation website
here
warning
Using SnowConvert
EWI
EWI page.
Using SnowConvert
here
here
here
here
here
here
here
here
Python package
here
here
Left is older version, right is newer version.
Left is older version, right is newer version.
Generated Python code comparison between versions 1.7.14 and 2.0.0