LogoLogo
SnowflakeDocumentation Home
  • Snowflake SnowConvert Documentation
  • General
    • About
    • Getting Started
      • System Requirements
      • Best practices
      • Download and Access
      • Code Extraction
        • Teradata
        • Oracle
        • SQL Server
        • Redshift
      • Running SnowConvert
        • Supported Languages
          • Teradata
          • Oracle
          • SQL Server
          • Redshift
          • Google BigQuery
          • Azure Synapse
          • Sybase IQ
          • Greenplum
        • Validation
          • Ambiguous Comments Validation
          • Extraction Validation
          • File Encoding Validation
          • File Extension Validation
          • File Format Validation
          • System Object Naming Validation
        • Assessment
          • Analyzing subfolders
        • Conversion
          • Converting subfolders
          • General Conversion Settings
          • Teradata Conversion Settings
          • Oracle Conversion Settings
          • Transact-SQL Conversion Settings
        • Review Results
          • SnowConvert Scopes
          • Output Code
          • Reports
            • Top-Level Code Units Report
            • Embedded Code Units Report
            • 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
              • Code Completeness Score
            • Issues Report
            • Missing Objects Report
            • Object References Report
            • Elements Report
            • Renaming Report
      • Training and Support
    • Conversion Software Terms of Use
      • Open Source Libraries
    • Release Notes
      • Recent Release Notes
      • Previous Release Notes By Platform
        • Teradata
          • Release Notes
            • 2024
            • 2023
            • 2022
            • 2021
            • 2020
            • Roadmap
        • Oracle
          • Release Notes
            • 2023
            • 2022
            • 2021
            • 2020
            • Roadmap
        • SQL Server
          • Release Notes
            • 2023
            • 2022
            • 2021
    • User Guide
      • SnowConvert
        • How to install the tool
          • Linux
          • Windows
          • MacOS
        • How to update the tool
        • How to get an access code
          • How to Retrieve Your UUID for SnowConvert Offline Activation in Linux
        • What is a SnowConvert Project?
        • How to use the SnowConvert CLI
        • Command Line Interface
          • Teradata
          • Oracle
          • Transact-SQL
          • Redshift
          • Renaming feature
      • SnowConvert for Redshift (Preview)
        • How to install the tool
          • Windows
          • MacOS
        • How to update the tool
        • How to inquire about an access code
        • What is a SnowConvert for Redshift project?
          • Project creation
          • Extraction
          • Conversion
          • Deployment
          • Data Migration
    • Technical Documentation
      • Understanding Converted Code
        • EWIs
          • General
            • SSC-EWI-0001
            • SSC-EWI-0002
            • SSC-EWI-0003
            • SSC-EWI-0004
            • SSC-EWI-0005
            • SSC-EWI-0006
            • SSC-EWI-0007
            • SSC-EWI-0008
            • SSC-EWI-0009
            • SSC-EWI-0010
            • SSC-EWI-0011
            • SSC-EWI-0012
            • SSC-EWI-0013
            • SSC-EWI-0014
            • SSC-EWI-0015
            • SSC-EWI-0020
            • SSC-EWI-0021
            • SSC-EWI-0022
            • SSC-EWI-0023
            • SSC-EWI-0025
            • SSC-EWI-0026
            • SSC-EWI-0027
            • SSC-EWI-0028
            • SSC-EWI-0030
            • SSC-EWI-0031
            • SSC-EWI-0033
            • SSC-EWI-0034
            • SSC-EWI-0035
            • SSC-EWI-0036
            • SSC-EWI-0040
            • SSC-EWI-0041
            • SSC-EWI-0045
            • SSC-EWI-0046
            • SSC-EWI-0049
            • SSC-EWI-0052
            • SSC-EWI-0053
            • SSC-EWI-0054
            • SSC-EWI-0056
            • SSC-EWI-0058
            • SSC-EWI-0062
            • SSC-EWI-0064
            • SSC-EWI-0066
            • SSC-EWI-0067
            • SSC-EWI-0068
            • SSC-EWI-0073
            • SSC-EWI-0077
            • SSC-EWI-0080
            • SSC-EWI-0084
            • SSC-EWI-0086
            • SSC-EWI-0092
            • SSC-EWI-0094
            • SSC-EWI-0101
            • SSC-EWI-0102
            • SSC-EWI-0107
            • SSC-EWI-0108
            • SSC-EWI-0109
            • SSC-EWI-0110
          • Teradata
            • SSC-EWI-TD0001
            • SSC-EWI-TD0002
            • SSC-EWI-TD0003
            • SSC-EWI-TD0004
            • SSC-EWI-TD0005
            • SSC-EWI-TD0006
            • SSC-EWI-TD0008
            • SSC-EWI-TD0009
            • SSC-EWI-TD0010
            • SSC-EWI-TD0012
            • SSC-EWI-TD0017
            • SSC-EWI-TD0020
            • SSC-EWI-TD0023
            • SSC-EWI-TD0024
            • SSC-EWI-TD0025
            • SSC-EWI-TD0027
            • SSC-EWI-TD0029
            • SSC-EWI-TD0031
            • SSC-EWI-TD0034
            • SSC-EWI-TD0039
            • SSC-EWI-TD0040
            • SSC-EWI-TD0041
            • SSC-EWI-TD0046
            • SSC-EWI-TD0049
            • SSC-EWI-TD0051
            • SSC-EWI-TD0052
            • SSC-EWI-TD0053
            • SSC-EWI-TD0055
            • SSC-EWI-TD0057
            • SSC-EWI-TD0059
            • SSC-EWI-TD0060
            • SSC-EWI-TD0061
            • SSC-EWI-TD0063
            • SSC-EWI-TD0066
            • SSC-EWI-TD0068
            • SSC-EWI-TD0069
            • SSC-EWI-TD0070
            • SSC-EWI-TD0076
            • SSC-EWI-TD0077
            • SSC-EWI-TD0079
            • SSC-EWI-TD0082
            • SSC-EWI-TD0083
            • SSC-EWI-TD0087
            • SSC-EWI-TD0091
          • Oracle
            • SSC-EWI-OR0001
            • SSC-EWI-OR0002
            • SSC-EWI-OR0004
            • SSC-EWI-OR0005
            • SSC-EWI-OR0006
            • SSC-EWI-OR0007
            • SSC-EWI-OR0008
            • SSC-EWI-OR0009
            • SSC-EWI-OR0010
            • SSC-EWI-OR0011
            • SSC-EWI-OR0013
            • SSC-EWI-OR0014
            • SSC-EWI-OR0016
            • SSC-EWI-OR0020
            • SSC-EWI-OR0023
            • SSC-EWI-OR0026
            • SSC-EWI-OR0029
            • SSC-EWI-OR0030
            • SSC-EWI-OR0031
            • SSC-EWI-OR0032
            • SSC-EWI-OR0033
            • SSC-EWI-OR0035
            • SSC-EWI-OR0036
            • SSC-EWI-OR0038
            • SSC-EWI-OR0039
            • SSC-EWI-OR0042
            • SSC-EWI-OR0045
            • SSC-EWI-OR0046
            • SSC-EWI-OR0047
            • SSC-EWI-OR0049
            • SSC-EWI-OR0050
            • SSC-EWI-OR0051
            • SSC-EWI-OR0052
            • SSC-EWI-OR0053
            • SSC-EWI-OR0057
            • SSC-EWI-OR0067
            • SSC-EWI-OR0068
            • SSC-EWI-OR0069
            • SSC-EWI-OR0070
            • SSC-EWI-OR0071
            • SSC-EWI-OR0072
            • SSC-EWI-OR0075
            • SSC-EWI-OR0076
            • SSC-EWI-OR0078
            • SSC-EWI-OR0082
            • SSC-EWI-OR0087
            • SSC-EWI-OR0089
            • SSC-EWI-OR0090
            • SSC-EWI-OR0092
            • SSC-EWI-OR0095
            • SSC-EWI-OR0097
            • SSC-EWI-OR0099
            • SSC-EWI-OR0100
            • SSC-EWI-OR0101
            • SSC-EWI-OR0103
            • SSC-EWI-OR0104
            • SSC-EWI-OR0105
            • SSC-EWI-OR0108
            • SSC-EWI-OR0109
            • SSC-EWI-OR0110
            • SSC-EWI-OR0116
            • SSC-EWI-OR0118
            • SSC-EWI-OR0121
            • SSC-EWI-OR0123
            • SSC-EWI-OR0126
            • SSC-EWI-OR0128
            • SSC-EWI-OR0129
            • SSC-EWI-OR0133
            • SSC-EWI-OR0135
            • SSC-EWI-OR0136
          • Transact-SQL
            • SSC-EWI-TS0001
            • SSC-EWI-TS0009
            • SSC-EWI-TS0010
            • SSC-EWI-TS0013
            • SSC-EWI-TS0016
            • SSC-EWI-TS0017
            • SSC-EWI-TS0023
            • SSC-EWI-TS0024
            • SSC-EWI-TS0025
            • SSC-EWI-TS0026
            • SSC-EWI-TS0032
            • SSC-EWI-TS0034
            • SSC-EWI-TS0035
            • SSC-EWI-TS0036
            • SSC-EWI-TS0037
            • SSC-EWI-TS0039
            • SSC-EWI-TS0041
            • SSC-EWI-TS0043
            • SSC-EWI-TS0044
            • SSC-EWI-TS0045
            • SSC-EWI-TS0046
            • SSC-EWI-TS0047
            • SSC-EWI-TS0049
            • SSC-EWI-TS0055
            • SSC-EWI-TS0056
            • SSC-EWI-TS0057
            • SSC-EWI-TS0060
            • SSC-EWI-TS0061
            • SSC-EWI-TS0063
            • SSC-EWI-TS0067
            • SSC-EWI-TS0070
            • SSC-EWI-TS0072
            • SSC-EWI-TS0073
            • SSC-EWI-TS0074
            • SSC-EWI-TS0075
            • SSC-EWI-TS0076
            • SSC-EWI-TS0077
            • SSC-EWI-TS0078
            • SSC-EWI-TS0079
            • SSC-EWI-TS0080
          • PostgreSQL
            • SSC-EWI-PG0001
            • SSC-EWI-PG0002
            • SSC-EWI-PG0003
            • SSC-EWI-PG0004
            • SSC-EWI-PG0005
            • SSC-EWI-PG0006
            • SSC-EWI-PG0008
            • SSC-EWI-PG0007
            • SSC-EWI-PG0009
            • SSC-EWI-PG0010
            • SSC-EWI-PG0011
            • SSC-EWI-PG0012
            • SSC-EWI-PG0014
            • SSC-EWI-PG0015
            • SSC-EWI-PG0016
          • Redshift
            • SSC-EWI-RS0002
            • SSC-EWI-RS0003
            • SSC-EWI-RS0004
            • SSC-EWI-RS0005
            • SSC-EWI-RS0006
            • SSC-EWI-RS0007
            • SSC-EWI-RS0008
            • SSC-EWI-RS0009
          • Sybase
            • SSC-EWI-SY0001
            • SSC-EWI-SY0002
            • SSC-EWI-SY0003
            • SSC-EWI-SY0004
            • SSC-EWI-SY0005
            • SSC-EWI-SY0006
            • SSC-EWI-SY0007
            • SSC-EWI-SY0008
            • SSC-EWI-SY0009
          • BigQuery
            • SSC-EWI-BQ0001
            • SSC-EWI-BQ0002
            • SSC-EWI-BQ0003
            • SSC-EWI-BQ0004
            • SSC-EWI-BQ0005
            • SSC-EWI-BQ0006
            • SSC-EWI-BQ0007
            • SSC-EWI-BQ0008
            • SSC-EWI-BQ0009
            • SSC-EWI-BQ0011
            • SSC-EWI-BQ0012
            • SSC-EWI-BQ0013
            • SSC-EWI-BQ0014
            • SSC-EWI-BQ0015
          • Greenplum
        • Functional Difference Messages
          • General
            • SSC-FDM-0001
            • SSC-FDM-0002
            • SSC-FDM-0003
            • SSC-FDM-0004
            • SSC-FDM-0005
            • SSC-FDM-0006
            • SSC-FDM-0007
            • SSC-FDM-0008
            • SSC-FDM-0009
            • SSC-FDM-0010
            • SSC-FDM-0011
            • SSC-FDM-0012
            • SSC-FDM-0013
            • SSC-FDM-0014
            • SSC-FDM-0015
            • SSC-FDM-0016
            • SSC-FDM-0017
            • SSC-FDM-0018
            • SSC-FDM-0019
            • SSC-FDM-0020
            • SSC-FDM-0021
            • SSC-FDM-0022
            • SSC-FDM-0023
            • SSC-FDM-0024
            • SSC-FDM-0026
            • SSC-FDM-0027
            • SSC-FDM-0028
            • SSC-FDM-0029
            • SSC-FDM-0030
            • SSC-FDM-0031
            • SSC-FDM-0032
            • SSC-FDM-0033
          • Teradata
            • SSC-FDM-TD0001
            • SSC-FDM-TD0002
            • SSC-FDM-TD0003
            • SSC-FDM-TD0004
            • SSC-FDM-TD0005
            • SSC-FDM-TD0006
            • SSC-FDM-TD0007
            • SSC-FDM-TD0008
            • SSC-FDM-TD0009
            • SSC-FDM-TD0010
            • SSC-FDM-TD0011
            • SSC-FDM-TD0012
            • SSC-FDM-TD0013
            • SSC-FDM-TD0014
            • SSC-FDM-TD0015
            • SSC-FDM-TD0016
            • SSC-FDM-TD0017
            • SSC-FDM-TD0018
            • SSC-FDM-TD0019
            • SSC-FDM-TD0020
            • SSC-FDM-TD0021
            • SSC-FDM-TD0022
            • SSC-FDM-TD0023
            • SSC-FDM-TD0024
            • SSC-FDM-TD0025
            • SSC-FDM-TD0026
            • SSC-FDM-TD0027
            • SSC-FDM-TD0028
            • SSC-FDM-TD0029
            • SSC-FDM-TD0030
            • SSC-FDM-TD0031
            • SSC-FDM-TD0032
            • SSC-FDM-TD0033
          • Oracle
            • SSC-FDM-OR0001
            • SSC-FDM-OR0002
            • SSC-FDM-OR0003
            • SSC-FDM-OR0004
            • SSC-FDM-OR0005
            • SSC-FDM-OR0006
            • SSC-FDM-OR0007
            • SSC-FDM-OR0008
            • SSC-FDM-OR0009
            • SSC-FDM-OR0010
            • SSC-FDM-OR0011
            • SSC-FDM-OR0012
            • SSC-FDM-OR0013
            • SSC-FDM-OR0014
            • SSC-FDM-OR0015
            • SSC-FDM-OR0016
            • SSC-FDM-OR0017
            • SSC-FDM-OR0018
            • SSC-FDM-OR0019
            • SSC-FDM-OR0020
            • SSC-FDM-OR0021
            • SSC-FDM-OR0022
            • SSC-FDM-OR0023
            • SSC-FDM-OR0024
            • SSC-FDM-OR0025
            • SSC-FDM-OR0026
            • SSC-FDM-OR0027
            • SSC-FDM-OR0028
            • SSC-FDM-OR0029
            • SSC-FDM-OR0030
            • SSC-FDM-OR0031
            • SSC-FDM-OR0032
            • SSC-FDM-OR0033
            • SSC-FDM-OR0034
            • SSC-FDM-OR0035
            • SSC-FDM-OR0036
            • SSC-FDM-OR0037
            • SSC-FDM-OR0038
            • SSC-FDM-OR0039
            • SSC-FDM-OR0040
            • SSC-FDM-OR0041
            • SSC-FDM-OR0042
            • SSC-FDM-OR0043
            • SSC-FDM-OR0044
            • SSC-FDM-OR0045
            • SSC-FDM-OR0046
            • SSC-FDM-OR0047
          • Transact-SQL
            • SSC-FDM-TS0001
            • SSC-FDM-TS0002
            • SSC-FDM-TS0003
            • SSC-FDM-TS0004
            • SSC-FDM-TS0005
            • SSC-FDM-TS0006
            • SSC-FDM-TS0007
            • SSC-FDM-TS0008
            • SSC-FDM-TS0009
            • SSC-FDM-TS0010
            • SSC-FDM-TS0011
            • SSC-FDM-TS0012
            • SSC-FDM-TS0013
            • SSC-FDM-TS0014
            • SSC-FDM-TS0015
            • SSC-FDM-TS0016
            • SSC-FDM-TS0017
            • SSC-FDM-TS0018
            • SSC-FDM-TS0019
            • SSC-FDM-TS0020
            • SSC-FDM-TS0021
            • SSC-FDM-TS0022
            • SSC-FDM-TS0023
            • SSC-FDM-TS0024
            • SSC-FDM-TS0025
            • SSC-FDM-TS0026
            • SSC-FDM-TS0027
            • SSC-FDM-TS0028
          • PostgreSQL
            • SSC-FDM-PG0001
            • SSC-FDM-PG0002
            • SSC-FDM-PG0003
            • SSC-FDM-PG0004
            • SSC-FDM-PG0005
            • SSC-FDM-PG0006
            • SSC-FDM-PG0007
            • SSC-FDM-PG0008
            • SSC-FDM-PG0009
            • SSC-FDM-PG0010
            • SSC-FDM-PG0011
            • SSC-FDM-PG0012
            • SSC-FDM-PG0013
            • SSC-FDM-PG0014
          • Redshift
            • SSC-FDM-RS0001
            • SSC-FDM-RS0002
            • SSC-FDM-RS0003
            • SSC-FDM-RS0004
            • SSC-FDM-RS0005
            • SSC-FDM-RS0006
            • SSC-FDM-RS0007
            • SSC-FDM-RS0008
          • Sybase
            • SSC-FDM-SY0001
            • SSC-FDM-SY0002
          • BigQuery
            • SSC-FDM-BQ0001
            • SSC-FDM-BQ0002
            • SSC-FDM-BQ0003
            • SSC-FDM-BQ0004
            • SSC-FDM-BQ0005
            • SSC-FDM-BQ0006
            • SSC-FDM-BQ0007
            • SSC-FDM-BQ0008
            • SSC-FDM-BQ0009
            • SSC-FDM-BQ0010
          • Greenplum
            • SSC-FDM-GP0001
        • Performance Review Messages
          • General
            • SSC-PRF-0001
            • SSC-PRF-0002
            • SSC-PRF-0003
            • SSC-PRF-0004
            • SSC-PRF-0005
            • SSC-PRF-0006
            • SSC-PRF-0007
          • Teradata
          • Oracle
          • Transact-SQL
            • SSC-PRF-TS0001
        • Out-of-Scope
          • SSC-OOS-0001
      • Function References
        • SnowConvert UDFs
        • Oracle
          • BFILENAME_UDF
          • CAST_DATE_UDF
          • CLOSE_BULK_CURSOR_UDF
          • DATE_TO_JULIAN_DAYS_UDF
          • DATE_TO_RR_FORMAT_UDF
          • DATEADD_UDF (DATE, FLOAT)
          • DATEADD_UDF (FLOAT, DATE)
          • DATEADD_UDF (TIMESTAMP, FLOAT)
          • DATEADD_UDF (FLOAT, TIMESTAMP)
          • DATEDIFF_UDF(DATE, DATE)
          • DATEDIFF_UDF(DATE, TIMESTAMP)
          • DATEDIFF_UDF(DATE, INTEGER)
          • DATEDIFF_UDF(TIMESTAMP, TIMESTAMP)
          • DATEDIFF_UDF(TIMESTAMP, DATE)
          • DATEDIFF_UDF(TIMESTAMP, NUMBER)
          • DBMS_OUTPUT.PUT_LINE_UDF
          • DBMS_RANDOM.VALUE_UDF
          • DBMS_RANDOM.VALUE_UDF (DOUBLE, DOUBLE)
          • FETCH_BULK_COLLECTION_RECORDS_UDF (OBJECT, FLOAT, ARRAY)
          • FETCH_BULK_COLLECTION_RECORDS_UDF (OBJECT)
          • FETCH_BULK_COLLECTION_RECORDS_UDF (OBJECT, INTEGER)
          • FETCH_BULK_COLLECTION_RECORDS_UDF (OBJECT, ARRAY)
          • FETCH_BULK_COLLECTIONS_UDF (OBJECT, FLOAT)
          • FETCH_BULK_COLLECTIONS_UDF (OBJECT)
          • FETCH_BULK_RECORD_COLLECTIONS_UDF (OBJECT, FLOAT, ARRAY)
          • FETCH_BULK_RECORD_COLLECTIONS_UDF (OBJECT)
          • FETCH_BULK_RECORD_COLLECTIONS_UDF (OBJECT, INTEGER)
          • FETCH_BULK_RECORD_COLLECTIONS_UDF (OBJECT, ARRAY)
          • INIT_CURSOR_UDF
          • JSON_VALUE_UDF
          • JULIAN_TO_GREGORIAN_DATE_UDF
          • OPEN_BULK_CURSOR_UDF (OBJECT, ARRAY)
          • OPEN_BULK_CURSOR_UDF (OBJECT)
          • REGEXP_LIKE_UDF (STRING, STRING, STRING)
          • REGEXP_LIKE_UDF (STRING, STRING)
          • TIMESTAMP_DIFF_UDF
          • UPDATE_PACKAGE_VARIABLE_STATE_UDF
          • UTL_FILE.FCLOSE_UDF
          • UTL_FILE.FOPEN_UDF (VARCHAR,VARCHAR)
          • UTL_FILE.FOPEN_UDF (VARCHAR, VARCHAR, VARCHAR)
          • UTL_FILE.PUT_LINE_UDF
        • Shared
          • DATEADD_UDF (DATE, STRING)
          • DATEADD_UDF (TIMESTAMP, STRING)
          • DATEADD_UDF (STRING, DATE)
          • DATEADD_UDF (STRING, TIMESTAMP)
          • DATEDIFF_UDF (DATE, STRING)
          • DATEDIFF_UDF (TIMESTAMP, STRING)
          • DATEDIFF_UDF (STRING, DATE)
          • DATEDIFF_UDF (STRING, TIMESTAMP)
          • INTERVAL_ADD_UDF (VARCHAR, VARCHAR, VARCHAR, VARCHAR, CHAR, VARCHAR)
          • INTERVAL_MULTIPLY_UDF (VARCHAR, VARCHAR, INTEGER)
          • INTERVAL_TO_MONTHS_UDF (VARCHAR)
          • INTERVAL_TO_SECONDS_UDF (VARCHAR, VARCHAR)
          • MONTHS_TO_INTERVAL_UDF (VARCHAR, NUMBER)
          • SECONDS_TO_INTERVAL_UDF (VARCHAR, NUMBER)
          • TO_INTERVAL_UDF (TIME)
          • TRUNC_UDF (TIMESTAMP_LTZ, VARCHAR)
          • TRUNC_UDF (NUMBER, NUMBER)
          • TRUNC_UDF (NUMBER)
          • TRUNC_UDF (TIMESTAMP_LTZ)
        • Transact-SQL
          • CAST_NUMERIC_TO_TIMESTAMP_TZ_UDF (NUMBER)
          • CAST_TIME_TO_TIMESTAMP_TZ_UDF (TIME)
          • CAST_TIMESTAMP_TZ_TO_NUMERIC_UDF (TIMESTAMP_TZ)
          • CONSTRAINT_OBJECT_ID_UDF (VARCHAR)
          • DB_ID_UDF(STRING)
          • ERROR_LINE_UDF
          • ERROR_NUMBER_UDF
          • ERROR_PROCEDURE_UDF
          • ERROR_SEVERITY_UDF
          • ERROR_STATE_UDF
          • FORMATMESSAGE_UDF
          • FUNCTION_OBJECT_ID_UDF (VARCHAR)
          • GET_CURRENT_TIMEZONE_UDF
          • IDENTITY_UDF
          • IS_MEMBER_UDF
          • ISDATE_UDF
          • ISNUMERIC_UDF
          • OBJECT_ID_UDF (VARCHAR)
          • OFFSET_FORMATTER (VARCHAR)
          • OPENXML_UDF
          • PARSENAME_UDF
          • PATINDEX_UDF
          • PROCEDURE_OBJECT_ID_UDF (VARCHAR)
          • QUOTENAME_UDF (VARCHAR, VARCHAR)
          • QUOTENAME_UDF (VARCHAR)
          • RAISERROR_UDF (DOUBLE, DOUBLE, DOUBLE, ARRAY)
          • RAISERROR_UDF (VARCHAR, DOUBLE, DOUBLE, ARRAY)
          • ROUND_MILLISECONDS_UDF (TIMESTAMP_TZ)
          • SEQUENCE_OBJECT_ID_UDF (VARCHAR)
          • STR_UDF (FLOAT, VARCHAR)
          • STR_UDF(FLOAT)
          • SUBTRACT_TIMESTAMP_TZ_UDF (TIMESTAMP_TZ, TIMESTAMP_TZ)
          • SUM_TIMESTAMP_TZ_UDF (TIMESTAMP_TZ, TIMESTAMP_TZ)
          • SWITCHOFFSET_UDF (TIMESTAMP_TZ, VARCHAR)
          • TABLE_OBJECT_ID_UDF (VARCHAR)
          • TRANSFORM_SP_EXECUTE_SQL_STRING_UDF(STRING, STRING, ARRAY, ARRAY)
          • FOR_XML_UDF (OBJECT, VARCHAR)
          • FOR_XML_UDF (OBJECT, VARCHAR, VARCHAR)
          • UPDATE_ERROR_VARS_UDF (STRING, STRING, STRING, STRING, STRING, STRING)
          • UPDATE_ERROR_VARS_UDF (STRING, STRING, STRING)
          • VIEW_OBJECT_ID_UDF (VARCHAR)
          • XML_JSON_SIMPLE
        • Teradata
          • CENTURY_UDF
          • CHAR2HEXINT_UDF
          • CHKNUM_UDF
          • COMPUTE_EXPAND_ON_UDF
          • DATE_LONG_UDF
          • DATE_TO_INT_UDF
          • DATEADD_UDF
          • DAY_OF_WEEK_LONG_UDF
          • DAYNAME_LONG_UDF (TIMESTAMP_TZ)
          • DAYNAME_LONG_UDF (TIMESTAMP_TZ, VARCHAR)
          • DAYNUMBER_OF_MONTH_UDF
          • DAYNUMBER_OF_YEAR_UDF
          • DIFF_TIME_PERIOD_UDF
          • EXPAND_ON_UDF
          • EXTRACT_TIMESTAMP_DIFFERENCE_UDF
          • FIRST_DAY_JANUARY_OF_ISO_UDF
          • FIRST_DAY_OF_MONTH_ISO_UDF
          • FULL_MONTH_NAME_UDF
          • GETQUERYBANDVALUE_UDF (VARCHAR, FLOAT, VARCHAR)
          • GETQUERYBANDVALUE_UDF (VARCHAR)
          • INSERT_CURRENCY_UDF
          • INSTR_UDF (STRING, STRING)
          • INSTR_UDF (STRING, STRING, INT)
          • INSTR_UDF (STRING, STRING, DOUBLE, DOUBLE)
          • INT_TO_DATE_UDF
          • INTERVAL_ADD_UDF
          • INTERVAL_MULTIPLY_UDF
          • INTERVAL_DIVIDE_UDF
          • INTERVAL_TO_MONTHS_UDF
          • INTERVAL_TO_SECONDS_UDF
          • ISO_YEAR_PART_UDF
          • JAROWINKLER_UDF
          • JSON_EXTRACT_DOT_NOTATION_UDF
          • JSON_EXTRACT_UDF
          • JULIAN_DAY_UDF
          • JULIAN_TO_DATE_UDF
          • LAST_DAY_DECEMBER_OF_ISO_UDF
          • MONTH_NAME_LONG_UDF
          • MONTH_SHORT_UDF
          • MONTHS_BETWEEN_UDF
          • NULLIFZERO_UDF
          • NVP_UDF
          • PERIOD_UDF
          • PERIOD_INTERSECT_UDF
          • PERIOD_OVERLAPS_UDF
          • PERIOD_TO_TIME_UDF
          • QUARTERNUMBER_OF_YEAR_UDF
          • ROMAN_NUMERALS_MONTH_UDF
          • ROUND_DATE_UDF
          • ROW_COUNT_UDF
          • SECONDS_PAST_MIDNIGHT_UDF
          • SUBSTR_UDF (STRING, FLOAT, FLOAT)
          • SUBSTR_UDF (STRING, FLOAT)
          • TD_DAY_OF_CALENDAR_UDF
          • TD_DAY_OF_WEEK_COMPATIBLE_UDF
          • TD_DAY_OF_WEEK_UDF
          • TD_MONTH_OF_CALENDAR_UDF
          • TD_WEEK_OF_CALENDAR_UDF
          • TD_WEEK_OF_YEAR_UDF
          • TD_YEAR_BEGIN_UDF
          • TD_YEAR_END_UDF
          • TIME_DIFFERENCE_UDF
          • TIMESTAMP_ADD_UDF
          • TIMESTAMP_DIFFERENCE_UDF
          • TO_BYTES_HEX_UDF
          • TRANSLATE_CHK_UDF
          • WEEK_NUMBER_OF_QUARTER_ISO_UDF
          • WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
          • WEEK_NUMBER_OF_QUARTER_UDF
          • WEEK_OF_MONTH_UDF
          • WEEKNUMBER_OF_MONTH_UDF
          • WRAP_NEGATIVE_WITH_ANGLE_BRACKETS_UDF
          • YEAR_BEGIN_ISO_UDF
          • YEAR_END_ISO_UDF
          • YEAR_PART_UDF
          • YEAR_WITH_COMMA_UDF
      • Considerations
        • Teradata
      • Glossary
    • Contact Us
    • Others
      • How to Use SnowConvert with Docker
    • Frequently Asked Questions (FAQ)
  • 📘Translation References
    • General
      • Subqueries
    • Teradata
      • Data Migration Considerations
        • UNION ALL Data Migration
      • Session Modes in Teradata
        • TERA Mode For Strings Comparison - NO COLLATE
        • TERA Mode For Strings Comparison - COLLATE
        • ANSI Mode For Strings Comparison - NO COLLATE
        • ANSI Mode For Strings Comparison - COLLATE
      • SQL Translation Reference
        • Data Types
        • DDL
          • Tables
            • WITH DEFAULT
          • Index
          • Views
          • Join Index
          • Schema
        • DML
          • Delete Statement
          • Insert Statement
            • LOGGING ERRORS
          • Select Statement
            • ANY Predicate
            • Expand On Clause
            • Normalize
            • Reset When
            • SAMPLE clause
          • Set Operators
          • Update Statement
          • With Modifier
        • Database DBC
        • Built-in Functions
          • CAST
            • Cast to INTERVAL datatype
            • Cast to DATE using { }
            • Cast from Number Datatypes to Varchar Datatype
          • CURRENT_TIMESTAMP
          • COALESCE
          • DAYNUMBER_OF_MONTH
          • FROM_BYTES
          • GETQUERYBANDVALUE
          • JSON_CHECK
          • JSON_EXTRACT
          • JSON_TABLE
          • NEW JSON
          • NVP
          • OVERLAPS
          • PIVOT
          • P_INTERSECT
          • RANK
          • Regex functions
          • STRTOK_SPLIT_TO_TABLE
          • SUBSTRING
          • TD_UNPIVOT
          • TO_CHAR
          • XMLAGG
      • SQL to Snowflake Scripting (Procedures)
        • CREATE PROCEDURE
        • CREATE MACRO
        • ACTIVITY_COUNT
        • ABORT and ROLLBACK
        • BEGIN END
        • CASE
        • CURSOR
        • DECLARE
        • DECLARE CONDITION HANDLER
        • DECLARE CONTINUE HANDLER
        • DML and DDL Objects
        • EXCEPTION HANDLERS
        • EXECUTE IMMEDIATE
        • EXECUTE/EXEC
        • FUNCTION OPTIONS OR DATA ACCESS
        • GET DIAGNOSTICS EXCEPTION
        • IF
        • LOCKING FOR ACCESS
        • LOOP
        • OUTPUT PARAMETERS
        • PREPARE
        • REPEAT
        • SET
        • SYSTEM_DEFINED
        • WHILE
      • SQL to JavaScript (Procedures)
        • Procedures
        • Macros
        • SnowConvert Procedures Helpers
          • Cursor Helper
          • Exec Helper
          • Functional Equivalence Helpers
          • Into Helper
        • GET DIAGNOSTICS EXCEPTION
      • Scripts to Snowflake SQL Translation Reference
        • COMMON STATEMENTS
          • ERROR HANDLING
          • EXIT or QUIT
          • GOTO
          • IF... THEN...
        • BTEQ
        • MLOAD
          • Import
      • Scripts To Python Translation Reference
        • BTEQ
          • REPEAT
          • USING REQUEST MODIFIER
        • FLOAD
          • BEGIN LOADING
        • MLOAD
          • BEGIN MLOAD
        • TPT
        • SnowConvert Scripts Helpers
          • Technical Documentation
    • Oracle
      • Sample data
      • Basic Elements of Oracle SQL
        • Data Types
          • Oracle Built-in Data Types
            • Character Data Types
              • CHAR Data type
              • NCHAR Data Type
              • VARCHAR2 Data Type
              • VARCHAR Data Type
              • NVARCHAR2 Data Type
            • Numeric Data Types
              • NUMBER Data Type
              • FLOAT Data Type
              • Floating-Point Numbers
                • BINARY_FLOAT
                • BINARY_DOUBLE
            • LONG Data Type
            • Datetime and Interval Data Types
              • DATE Data Type
              • TIMESTAMP Data Type
              • TIMESTAMP WITH TIME ZONE Data Type
              • TIMESTAMP WITH LOCAL TIME ZONE Data Type
              • INTERVAL YEAR TO MONTH Data Type
              • INTERVAL DAY TO SECOND Data Type
              • Datetime Arithmetic
                • Interval UDFs vs Snowflake native interval operation
            • LOB Data Types
              • BFILE Data Type
              • BLOB Data Type
              • CLOB Data Type
              • NCLOB Data type
            • JSON Data Type
            • Extended Data Types
            • RAW and LONG RAW Data types
            • PL SQL Data Types
              • PLS_INTEGER Data Type
              • BINARY_INTEGER Data Type
          • Rowid Data Type
            • ROWID DataType
            • UROWID Data Type
          • ANSI Data Types
          • User-Defined Types
            • REF Data Types
          • Any Types
            • ANYTYPE
            • ANYDATA
            • ANYDATASET
          • XML Types
            • XMLType
            • URI Data Types
              • HTTPURIType
              • XDBURIType
              • DBURIType
            • URIFactory Package
          • Spatial Types
            • SDO_GEOMETRY
            • SDO_TOPO_GEOMETRY
            • SDO_GEORASTER
          • Data Type Customization
        • Literals
          • Interval Literal
          • Interval Type and Date Type
          • Text literals
      • Pseudocolumns
        • ROWID
        • ROWNUM
      • Built-in functions
        • SnowConvert Custom UDFs
          • BFILENAME UDF
          • DATE_TO_JULIANDAYS_UDF
          • DATEADD UDF
          • DATEDIFF UDF
          • INTERVAL UDFs
            • DATEADD UDF INTERVAL
            • DATEDIFF UDF INTERVAL
          • CAST_DATE UDF
          • JSON_VALUE UDF
          • JULIAN TO GREGORIAN DATE UDF
          • MONTHS BETWEEN UDF [DEPRECATED]
          • REGEXP LIKE UDF
          • TIMESTAMP DIFF UDF
          • TRUNC (date) UDF
          • TRUNC (number) UDF
        • TO_NUMBER
        • NLSSORT
      • Built-In packages
        • DBMS_LOB
          • SUBSTR Function
        • DBMS_RANDOM
          • VALUE functions
        • DBMS_OUTPUT
          • PUT_LINE procedure
        • UTL_FILE
          • FOPEN procedure
          • PUT_LINE procedure
          • FCLOSE procedure
      • SQL Queries and Subqueries
        • Select
          • Select Flashback Query
        • Joins
          • Equijoin
          • Band Join
          • Self Join
          • Cartesian Products
          • Inner Join
          • Outer Join
          • Antijoin
          • Semijoin
      • SQL Statements
        • Alter Session
        • Alter Table
        • Create Materialized Views
        • Create Database Link
        • Create Index
        • Create Sequence
        • Create Synonym
        • Create Table
        • Create Type
          • Object Type Definition
          • Subtype Definition
          • Array Type Definition
          • Nested Table Type Definition
          • Member Function Definitions
        • Create View
        • Drop Table
      • PL/SQL to Snowflake Scripting
        • ASSIGNMENT STATEMENT
        • CALL
        • CASE
        • COLLECTIONS AND RECORDS
          • Associative Array Type Definition
          • Varray Type Definition
          • Nested Table Array Type Definition
          • Collection Methods
          • Collection Bulk Operations
            • WITH, SELECT, and BULK COLLECT INTO statements
          • Record Type Definition
        • COMPOUND STATEMENTS
        • CONTINUE
        • CREATE PROCEDURE
        • CREATE FUNCTION
          • Cursor for a return variable
          • Cursor with IF statement
          • Multiples IFs statement
        • CURSOR
          • PARAMETRIZED CURSOR
          • CURSOR DECLARATION
          • Workaround for cursors using parameters or procedure variables
          • Cursor Variables
        • DECLARE
        • DEFAULT PARAMETERS
        • DML STATEMENTS
          • INSERT Statement Extension
          • MERGE Statement
          • SELECT INTO Statement
          • Work around to simulate the use of Records
        • EXIT
        • EXPRESSIONS
        • EXECUTE IMMEDIATE
        • FORALL
        • FOR LOOP
        • HELPERS
          • Bulk Cursor Helpers
        • IF
        • IS EMPTY
        • LOCK TABLE
        • LOG ERROR
        • LOOP
        • OUTPUT PARAMETERS
        • PACKAGES
          • DECLARATION
          • BODY
          • VARIABLES
          • Constants
        • PROCEDURE CALL
        • RAISE
        • RAISE_APPICATION_ERROR
        • UDF CALL
        • WHILE
      • PL/SQL to Javascript
        • Procedures
        • User defined functions
        • Packages
        • Helpers
          • EXEC Helper
          • Cursor Helper
          • Raise Helper
          • ROWTYPE Helper
          • Between operator helper
          • Like operator Helper
          • IS NULL Helper
          • Concat Value Helper
          • Package variables helper
          • Implicit Cursor attribute helper
        • Declarations
        • Control Statements
        • Conditional Compilation
        • Collections & Records
        • DDL - DML Statements
        • SQL Language Elements
        • Expressions and operators
        • Synonyms
        • Triggers
        • TYPE attribute
      • SQL*Plus
        • Archive Log
        • Attribute
        • Break
        • Btitle
        • Change
        • Column
        • Define
        • Host
        • Prompt
        • Remark
        • Set
        • Spool
        • Start
        • Whenever oserror
        • Whenever sqlerror
        • Show
        • Append
        • Accept
      • Wrapped objects
    • Transact-SQL
      • General Language Elements
        • COMPUTED COLUMN
        • EXECUTE
          • System Store Procedures
            • SP_RENAME
            • SP_EXECUTESQL
        • Collate
        • USE
        • OUTER APPLY
      • DDLs
        • Tables
          • Azure Synapse Analytics
          • TEXTIMAGE_ON
        • Index
        • Views
        • Materialized View
        • Procedures
        • FUNCTION
          • SCALAR
          • INLINE TABLE-VALUED
          • MULTI-STATEMENT TABLE-VALUED
      • DMLs
        • Set Operators
        • Between
        • Update
          • UPDATE with LEFT and RIGHT JOIN
        • Select
        • Insert
        • Delete
        • Merge
        • Exists
        • IN
        • Truncate
        • Bulk Insert
        • Common Table Expression (CTE)
        • Drops
      • Data Types
      • Statements
        • ALTER
          • TABLE
            • ADD
              • COLUMN DEFINITION
                • COLUMN CONSTRAINT
                  • FOREIGN KEY
                  • PRIMARY KEY / UNIQUE
                  • CHECK
              • TABLE CONSTRAINT
                • FOREIGN KEY
                • PRIMARY KEY
                • CHECK
                • CONNECTION
                • DEFAULT
                • ON PARTITION
            • CHECK CONSTRAINT
        • SET
          • ANSI_NULLS
      • Built-in functions
        • SnowConvert custom UDFs
          • OPENXML UDF
          • STR UDF
          • SWITCHOFFSET_UDF
        • Aggregate functions
          • COUNT
          • COUNT_BIG
          • SUM
        • Analytic Functions
          • LAG
        • Conversion functions
          • CONVERT
          • TRY_CONVERT
        • Data Type functions
          • DATALENGTH
        • Date & Time functions
          • AT TIME ZONE
          • SWITCHOFFSET
          • DATEADD
          • DATEDIFF
          • DATEPART
          • DATEFROMPARTS
          • DATENAME
          • DAY
          • EOMONTH
          • GETDATE
          • MONTH
          • SYSDATETIME
          • SYSUTCDATETIME
          • YEAR
        • Logical functions
          • IIF
        • Mathematical functions
          • ABS
          • ACOS
            • ACOS in JS
          • ASIN
            • ASIN in JS
          • ATAN
            • ATAN in JS
          • ATN2
            • ATAN2 in JS
          • AVG
          • CEILING
          • COS
            • COS in JS
          • COT
            • COT in JS
          • DEGREES
            • DEGREES in JS
          • EXP
            • EXP in JS
          • FLOOR
          • LOG
            • LOG in JS
          • LOG10
            • LOG10 in JS
          • PI
            • PI in JS
          • POWER
            • POW in JS
          • SQUARE
          • STDEV
          • STDEVP
          • VAR
          • POWER
          • RADIANS
            • RADIANS in JS
          • ROUND
          • SQRT
        • Metadata functions
          • DB_NAME
          • OBJECT_ID
        • Ranking functions
          • DENSE_RANK
          • RANK
          • ROW_NUMBER
        • String functions
          • ASCII
            • ASCII in JS
          • CHAR
          • CHARINDEX
          • COALESCE
          • CONCAT
          • CONCAT_WS
            • Join in JS
          • DIFFERENCE
            • DIFFERENCE in JS
          • FORMAT
            • FORMAT in JS
          • LEFT
          • LEN
          • LOWER
          • LTRIM
            • LTRIM in JS
          • NCHAR
          • PATINDEX
            • search in JS
          • QUOTENAME
            • QUOTENAME in JS
          • REPLACE
          • REPLICATE
          • REVERSE
            • reverse in JS
          • RIGHT
          • RTRIM
          • SOUNDEX
            • SOUNDEX in JS
          • SPACE
          • STR
            • STR in JS
          • STRING_ESCAPE
            • stringify in JS
          • SUBSTRING
          • TRIM
            • trim in JS
          • UPPER
        • System functions
          • FORMATMESSAGE
            • FORMATMESSAGE_UDF
          • ISNULL
          • NEWID
          • NULLIF
          • @@ROWCOUNT
        • XML Functions
          • Value
          • Query
      • Built-in procedures
        • Custom User Defined Procedures
          • SP_ADDEXTENDEDPROPERTY_UDP
      • Snowflake Scripting
        • CREATE PROCEDURE
        • CASE
        • CURSOR
        • DECLARE
        • EXECUTE
        • IF
        • SET
        • CALL
        • WHILE
        • BEGIN and COMMIT Transaction
        • OUTPUT PARAMETERS
        • LABEL and GOTO
        • TRY CATCH
      • System Tables
        • SYS.FOREIGN_KEYS
      • Queries
        • SELECT
        • TOP
    • Sybase IQ
      • SQL Statements
        • CREATE TABLE
          • TEMPORARY TABLES
          • IF NOT EXISTS
          • (ENABLE | DISABLE) RLV STORE
          • IN DBSPACE
          • ON COMMIT
          • AT LOCATION
          • PARTITION BY
          • CONSTRAINTS
          • DEFAULT
        • CREATE VIEW
        • SELECT
      • Built-in functions
      • Data Types
    • Redshift
      • Basic elements
        • Names and identifiers
        • Reserved Keywords
        • Literals
          • NULLS
          • Date, time, and timestamp literals
          • Interval Literals
      • Expressions
        • Compound Expressions
          • Bitwise operators
          • Arithmetic operators
        • Expression lists
      • Conditions
        • Comparison Condition
        • Logical Conditions
        • Pattern-matching conditions
          • LIKE
          • SIMILAR TO
          • POSIX Operators
        • BETWEEN
        • NULL
        • IN
        • EXISTS
      • Data types
        • INTERVAL YEAR TO MONTH Data Type
        • INTERVAL DAY TO SECOND Data Type
        • Numeric Format Models
      • SQL Statements
        • CALL
        • CREATE TABLE AS
          • Table Start
            • LOCAL
            • COLUMNS
            • BACKUP
          • Tabla Attributes
            • DISTSTYLE
            • DISTKEY
            • SORTKEY
        • CREATE TABLE
          • Table Start
            • LOCAL
            • IF NOT EXISTS
            • BACKUP
          • Column Attributes
            • DEFAULT
            • IDENTITY
            • GENERATED BY DEFAULT AS IDENTITY
            • ENCODE
            • DISTKEY
            • SORTKEY
            • COLLATE
          • Column Constraint
            • NOT NULL | NULL
            • UNIQUE | PRIMARY KEY
            • REFERENCES
          • Table Constraints
            • UNIQUE
            • PRIMARY KEY
            • FOREIGN KEY
          • Table Attributes
            • DISTSTYLE
            • DISTKEY
            • SORTKEY
            • ENCODE
        • CREATE EXTERNAL TABLE
        • CREATE VIEW
        • CREATE FUNCTION
        • CREATE MATERIALIZED VIEW
        • CREATE PROCEDURE
          • ARGUMENTS MODE
          • POSITIONAL ARGUMENTS
          • NONATOMIC
          • PROCEDURE BODY
            • BLOCK STATEMENT
            • DECLARE
            • ALIAS DECLARATION
            • VARIABLE DECLARATION
            • LABEL
            • CURSORS
              • DECLARE CURSOR
                • DECLARE REFCURSOR
              • OPEN CURSOR
              • FETCH CURSOR
              • CLOSE CURSOR
            • LOOPS
              • LOOP
              • WHILE
              • FOR
              • EXIT
              • CONTINUE
            • TRANSACTIONS
              • COMMIT
              • ROLLBACK
              • TRUNCATE
            • RAISE
            • EXCEPTION
            • RETURN
            • CONDITIONS
              • IF
              • CASE
          • SECURITY (DEFINER | INVOKER)
        • CREATE SCHEMA
        • CREATE DATABASE
        • DELETE
        • INSERT
        • SELECT
          • WITH clause
          • SELECT list
          • FROM clause
          • WHERE clause
          • CONNECT BY clause
          • GROUP BY clause
          • HAVING clause
          • QUALIFY clause
          • UNION, INTERSECT, and EXCEPT
          • ORDER BY clause
        • SELECT INTO
          • WITH clause
          • SELECT list
          • FROM clause
          • WHERE clause
          • GROUP BY clause
          • HAVING clause
          • UNION, INTERSECT, and EXCEPT
          • ORDER BY clause
          • LIMIT and OFFSET clauses
          • Local Variables and Parameters
        • MERGE
        • UPDATE
        • EXECUTE
      • Built-in functions
        • TO_CHAR
          • For datetime values
        • IDENTITY
      • System catalog tables
  • BigQuery
    • Identifier differences between BigQuery and Snowflake
    • Sql Statements
      • CREATE EXTERNAL TABLE
      • CREATE VIEW
        • View column name list
        • View Options
      • CREATE TABLE
        • COLUMN DEFINITION
      • CREATE TABLE LIKE
      • CREATE TABLE COPY
      • CREATE TABLE SNAPSHOT
      • CREATE TABLE CLONE
    • Data types
      • ANY TYPE
      • ARRAY<T>
      • BYTES
      • GEOGRAPHY
      • INTERVAL
      • JSON
      • STRUCT
      • TIMESTAMP
    • Built-in functions
      • ST_GEOGFROMTEXT
      • FORMAT_DATE
      • ST_GEOGPOINT
    • Operators
  • Greenplum
    • Built-in functions
      • TO_CHAR
        • For datetime values
    • Data Types
    • DDLs
      • CREATE MATERIALIZE VIEW
      • CREATE TABLE
      • CREATE VIEW
  • SQL Engine Release Notes
    • Release Notes
      • 2024
      • 2023
  • SnowConvert AI
    • SnowConvert Migration Assistant
      • Getting Started
      • Troubleshooting
      • Billing
      • Legal Notices
Powered by GitBook
On this page
  • Release 2.0.264 - December 19th, 2022
  • Release 2.0.259 - December 12th, 2022
  • Release 2.0.246 - November 21st, 2022
  • Release 2.0.235 - November 10th, 2022
  • Release 2.0.218 - October 24th, 2022
  • Release 2.0.200 - October 10th, 2022
  • Release 2.0.173 - September 26th, 2022
  • Release 2.0.156 - September 12th, 2022
  • Release 2.0.130 - August 29th, 2022
  • Release 2.0.112 - August 16th, 2022
  • Release 2.0.95 - August 3rd, 2022
  • Release 2.0.89 - August 1st, 2022
  • Release 2.0.73 - July 18th, 2022
  • Release 2.0.70 - July 12th, 2022
  • Release 2.0.61 - July 4th, 2022
  • Release 2.0.38 - Jun 21th, 2022
  • Release 2.0.21 - Jun 7th, 2022
  • Release 2.0.6 - May 25th, 2022
  • Release 1.5.77 - May 10th, 2022
  • Release 1.5.56 - April 25th, 2022
  • Release 1.5.41 - April 12th, 2022
  • Release 1.5.19 - March 28th, 2022
  • Release 1.4.140 - March 14th, 2022
  • Release 1.4.140 - March 14th, 2022
  • Release 1.4.117 - February 28th, 2022
  • Release 1.4.98 - February 14th, 2022
  • Release 1.4.74 - February 1st, 2022
  • Release 1.4.58 - January 18th, 2022
  • Release 1.4.32 - January 3rd, 2022
  • Release 1.4.1 - December 22nd, 2021
  • Release 1.3.4 - December 7th, 2021
  • Release 1.3.3 - November 22nd, 2021
  • Release 1.3.1 - November 8th, 2021
  • Release 1.3.0 - October 25th, 2021
  • Release 1.2.1 - October 11th, 2021
  • Release 1.2.0 - September 28th, 2021
  • Release 1.1.17 - September 14th, 2021
  • Release 1.1.16 - August 31st, 2021
  • Release 1.1.15 - August 18th, 2021
  • Release 1.1.14 - August 16th, 2021
  • Release 1.1.12 - August 4th, 2021
  • Release 1.1.11 - July 19th, 2021
  • Release 1.1.10 - July 6th, 2021
  • Release 1.1.9 - June 22nd, 2021
  • Release 1.1.5 - June 9th, 2021
  • Release 1.1.3 - May 25th, 2021
  • Release 1.1.2 - May 14th, 2021
  • SnowConvert Core 3.0.3
  1. General
  2. Release Notes
  3. Previous Release Notes By Platform
  4. SQL Server
  5. Release Notes

2022

Release 2.0.264 - December 19th, 2022

SnowConvert Core 13.0.16

Added

  • Translation for function DB_NAME

  • Translation for function SYSUTCDATETIME

  • Translation of CAST parameter used to style format from date to string

Fixed

  • The result of the AT TIME ZONE is different in the .csv of SQL Server and the .csv of Snowflake

  • ALTER TABLE ADD COLUMN CONSTRAINT adds invalid IF EXISTS statement

  • Fix to be inline as the date to string CAST documentation

Release 2.0.259 - December 12th, 2022

SnowConvert Core 12.0.0

Added

  • CTE + INSERT has an incorrect conversion

  • Stabilize using Elements Report Category/GrammarElement resolvers

  • Generate object breakdown section in HTML Conversion Report

  • Generate File breakdown section in HTML Conversion Report

Fixed

  • Reduce procedure exceptions in some customer workloads

  • EWI1040 is displayed but it should display EWI4063

  • Regression due to SQL Changes in DotDouble Operator

  • Stackoverflow migrating ALTER TABLE ADD CONSTRAINT

Release 2.0.246 - November 21st, 2022

SnowConvert Core 11.0.108

Added

  • Procedures with unsupported options gives 0 % conversion rate

  • Translate OPENXML table valued function

  • Add a footer to HTML Conversion Report

  • Generate File breakdown section in HTML Conversion Report

Fixed

  • Function should be preserved as Function

  • Cast issues for date/time not correctly converted

  • Some generated Javascript function is invalid

  • Date & Time functions do not work properly

  • Exception in CREATE TABLE statement

Release 2.0.235 - November 10th, 2022

SnowConvert Core 11.0.62

Added

  • Support for GETUTCDATE function

  • Translation of Output parameter should be declared and returned

  • Generate overall conversion summary section in HTML Conversion Report

  • Generate issues breakdown section in HTML Conversion Report

Fixed

  • FORMATMESSAGE Function Not Supported

  • Functions defined in the code are generating EWI1031 when referenced

  • SQL N strings are lost inside some Store Procedures

  • Function Generated Javascript but it should be using the Target language selected

Release 2.0.218 - October 24th, 2022

SnowConvert Core 10.0.0

Added

  • Remove Cartesian Product from the UPDATE statement

  • Create a UDF function equivalent to xplogininfo

  • Transform Bitwise operations

  • Translate Expression AT TIME ZONE

  • Translate CTE in SELECT and CREATE VIEW

Fixed

  • Cast issues for date/time not correctly converted

  • Ewis and expected code were not generated according to ALTER TABLE documentation

  • File not generated with XP_LOGININFO in INSERT

  • The table Named with @ should be replaced by T_ and the temporary table

  • Parsing error for MERGE @Table statement

Release 2.0.200 - October 10th, 2022

SnowConvert Core 9.2.72

Added

  • [Alter Table] Function SWITCHOFFSET must be converted

  • [Alter Table] Parse ALTER TABLE data type

  • [Alter Table] Save ALTER TABLE default values to a CREATE TABLE statement

  • [UI] Change DBObject Name Conversion Setting text and default option to NONE

Fixed

  • Comments lost in the header of procedures

  • TopLevelQueries were not generated when only dynamic SQL queries

Release 2.0.173 - September 26th, 2022

SnowConvert Core 9.2.6

Added

  • [Alter Table] [Translation] IDENTITY column option

  • [Alter Table] Enable transformation for MEF default constraints collected

  • [Alter Table] [Translation] SPARSE column option

Fixed

  • Division of integer values must add trunc function

  • Binary expression '+' must be converted to || Snowflake concatenation

Release 2.0.156 - September 12th, 2022

SnowConvert Core 9.0.37

Added

  • Data types should be converted properly

Fixed

  • DATEADD and DATEDIFF are giving issues converted together

  • Function EOMONTH should be appropriately converted

  • Store procedures Header comments are not added in the correct location

  • Unexpected 'AS' for incorrect transformation of DATE_PART

Release 2.0.130 - August 29th, 2022

SnowConvert Core 7.11.122

Added

  • Translate MASKED WITH (FUNCTION = 'mask_function')

  • Create more specific EWI for unsupported types

  • [UDF] Transform User Defined Functions with Nested IF depth greater than 1

  • Translation for unsupported Table Elements within ALTER TABLE

Fixed

  • Missing SELECT helper in a stored procedure

Release 2.0.112 - August 16th, 2022

SnowConvert Core 7.11.83

Added

  • Translate scope_identity function

  • Transform ALTER TABLE Default Constraint using CREATE TABLE statement

  • Refactor TSqlsStat AST

Fixed

  • Some duplicated procedure names with no schema are lost during arrange preprocess

  • Added cast to return value when return type should be DATE

Release 2.0.95 - August 3rd, 2022

SnowConvert Core 7.11.47

Added

  • Translate DEFAULT property in ALTER TABLE statement

  • Remove ALTER TABLE unsupported table options

Release 2.0.89 - August 1st, 2022

SnowConvert Core 7.11.22

Added

  • Translate SET statements inside IF/ELSE blocks

  • Translate SELECT statements inside IF/ELSE blocks

  • Parse ALTER TABLE rebuild option

  • Remove ALTER TABLE column constraint options

Fixed

  • Arrange with the pretty print flag causes an exception

  • Dates expressed by numbers are not converted properly

  • Scalar function transformed to procedure instead of Snowflake function

Release 2.0.73 - July 18th, 2022

SnowConvert Core 7.9.154

Added

  • Robustness on the parser for ALTER TABLE statement

Fixed

  • User-defined function transformed to stored procedure instead of user-defined function

Release 2.0.70 - July 12th, 2022

SnowConvert Core 7.9.130

Added

  • [Snowflake Scripting] Transformation for variable assignment in SELECT

Fixed

  • Preserve comments above the DDLs definition

  • Input parameter argument binding

Release 2.0.61 - July 4th, 2022

SnowConvert Core 7.9.95

Added

  • Robustness on the parser for ALTER TABLES

  • Translation for DECLARE statements inside IF/ELSE blocks inside user-defined functions. See also MSCEWI4049.

  • Preprocessing for ALTER TABLE statement.

Fixed:

  • Body not generated in several user-defined functions.

  • Temporal table name reference in update statement.

  • Parameters references in SELECT queries that use columns with the same names.

Release 2.0.38 - Jun 21th, 2022

SnowConvert Core 7.9.34

Added

Lines of code conversion rate mode is now available.

By default, the conversion rate is calculated per character transformed for more precision. Now, the user can select how this calculation is done by choosing between lines of code or characters.

Fixed:

  • Deployment issue on TEMPORARY tables without OR REPLACE keyword

  • Translated statements without semicolon in Snowflake Scripting

Release 2.0.21 - Jun 7th, 2022

SnowConvert Core 7.3.0

Added:

  • Warning for not supported statements that should be commented out.

  • New EULA file with an updated version

Fixed:

  • Parsing exception in macOS

Release 2.0.6 - May 25th, 2022

SnowConvert Core 7.2.6

Added:

  • General improvements on the Pretty Print performance and output code

    • COALESCE

    • COUNT

    • LAG

    • AVG

    • SPACE

    • DENSE_RANK

    • LOWER

    • REVERSE

    • FIRST_VALUE

    • FLOOR

    • SIGN

    • SQUARE

    • USER_NAME

    • LEAD

    • EXP

    • LAST_VALUE

    • CONCAT_WS

    • LOG

    • ASCII

    • RAND

    • ISJSON

    • COS

    • PERCENTILE_DISC

    • SIN

    • GROUPING

    • ACOS

    • NTILE

    • UNICODE

    • RADIANS

    • SOUNDEX

Fixed:

  • Transformation for User Defined Functions calls marked as errors.

Version 2.0.6 of SnowConvert for SQL Server is not available in macOS

Release 1.5.77 - May 10th, 2022

SnowConvert Core 5.0.132

Added:

  • Transformation for multiple return statements inside User Defined Functions

  • Transformation for IS_MEMBER conversion

    • CONCAT

    • COUNT_BIG

    • DATALENGTH

    • DATEDIFF

    • DATEFROMPARTS

    • DATENAME

    • EOMONTH

    • GETDATE

    • ISDATE

    • ISNULL

    • LEFT

    • LEN

    • LTRIM

    • MAX

    • MIN

    • NEWID

    • NULLIF

    • PATINDEX

    • POWER

    • RANK

    • REPLACE

    • REPLICATE

    • RIGHT

    • ROW_NUMBER

    • DATEADD

    • SUM

Fixed:

  • Transformation for INSERT statement without INTO clause

  • Transformation for User Defined Functions to Stored Procedures without helpers

  • Transformation for IIF function that was wrongly mapped

  • Comment out default value for BINARY column definitions

Release 1.5.56 - April 25th, 2022

SnowConvert Core 5.0.88

Added:

  • Improvements to code preprocessing documentation in UI

Fixed:

  • NUMBER datatypes with no scale transformation

Release 1.5.41 - April 12th, 2022

SnowConvert Core 5.0.71

Added:

  • Functional equivalence review for built-in functions such as:

Fixed:

  • HTML assessment report generation

Release 1.5.19 - March 28th, 2022

SnowConvert Core 5.0.35

Added:

  • Procedures target transformation to Snowflake Scripting (UI and CLI)

  • Robustness on the parser for CREATE PROCEDURES

Fixed:

  • Transformation for multiple declarations in user defined functions

  • Transformation for user defined functions with body not generated

Release 1.4.140 - March 14th, 2022

SnowConvert Core 4.0.108

Added:

  • Transformation for User Defined Functions with multiple IF statements without the ELSE clause

  • Transformation for User Defined Functions with variable self assignment pattern inside SELECT statements (only applies to SELECT Statements without the FROM clause)

  • Transformation for multiple return statements inside User Defined Functions (only applies to functions without statements transformed to Common Table Expressions)

  • Robustness on parser in Stored Procedures

Release 1.4.140 - March 14th, 2022

SnowConvert Core 4.0.108

Added:

  • Transformation for User Defined Functions with multiple IF statements without the ELSE clause

  • Transformation for User Defined Functions with variable self assignment pattern inside SELECT statements (only applies to SELECT Statements without the FROM clause)

  • Transformation for multiple return statements inside User Defined Functions (only applies to functions without statements transformed to Common Table Expressions)

  • Robustness on parser in Stored Procedures

Release 1.4.117 - February 28th, 2022

SnowConvert Core 4.0.60

Added

  • UnrecognizedElementsLOC to Assessment.docx and Assessment.csv

Release 1.4.98 - February 14th, 2022

SnowConvert Core 4.0.33

Added

  • Transformation for basic IF statement inside user defined functions

  • Warnings for:

  • IMMUTABLE keyword to all generated UDF helpers

  • Glossary section of the main concepts in the Assessment.docx report

  • Added 2 precision decimals to the conversion rates of the assessment reports to improve precision

Fixed

  • Thrown exception while translate names with special characters

  • Thrown exception inside Table-Valued function with qualified name

  • Empty object names in the Top-level objects report

Release 1.4.74 - February 1st, 2022

SnowConvert Core 3.2.86

Added

  • Improved transformations for CURRENT_DATE and DATE_PART

  • Parsing improvements for AUTO keyword, FROM clause and WITH alias

  • Several improvements to UDFs translations, including:

    • Add cast to columns inside union all when semantic information was not found

    • Add warning to function expressions identified as user-defined functions

    • Translation for parameter usages inside queries in inline table valued functions

    • Support for semicolons inside SQL functions

Fixed

  • Exception in OBJECT_ID with non string parameter

  • Exception in SET with square brackets with blank space in update clause

  • Several MSCEWI1013 instances

  • CURSOR error when the result is only 1 row

Release 1.4.58 - January 18th, 2022

SnowConvert Core 3.2.67

Added

  • Transformation for user-defined functions with SET and DECLARE statements

  • Transformation for variable assignment using SELECT inside user-defined functions

  • Transformation for user-defined function calls inside STORED PROCEDURES

  • Improvements on Object Conversion rate assessment

Fixed

  • Transformation for WITH statement with multiple COMMON TABLE EXPRESSIONS

  • Transformation for SELECT setting multiple variables

  • Thrown exception while transforming identifiers with square brackets

Release 1.4.32 - January 3rd, 2022

SnowConvert Core 3.2.34

Added

  • Transformation for OUTER APPLY clause.

  • Accuracy improvements on Assessment Object conversion rate.

  • Transformation for User-Defined functions that can only be translated to Stored Procedures

  • Robustness on parser on SELECT statements.

Fixed

  • Thrown exception on maintain folder structure flag while preprocessing the code

Release 1.4.1 - December 22nd, 2021

SnowConvert Core 3.2.16

Added

  • Robustness on parser on SELECT statements.

  • Code preprocess before converting the source code. Learn more

  • Accuracy improvements on Assessment.

Fixed

  • Cursor error when the result is only 1 row inside Stored Procedures

  • Unhandled exception while converting OBJECT_ID

  • Transformation for temporal (#) tables

  • Unhandled exception while converting aliases with special characters or spaces.

  • Unhandled exception while converting MERGE statements

Release 1.3.4 - December 7th, 2021

SnowConvert Core 3.1.43

Fixed

  • Transformation for string concatenation using +

Release 1.3.3 - November 22nd, 2021

SnowConvert Core 3.1.24

Added

Fixed

  • Transformation for MONEY and SMALLMONEY

  • Transformation for TABLE datatype in stored procedures

  • Error on SELECT helper

  • Transformation for addition assignment operators (+=, -=)

  • Transformation for UPDATE statements using the table alias as target

  • Comments lost during stored procedures transformation.

Release 1.3.1 - November 8th, 2021

SnowConvert Core 3.1.20

Added

  • Count of User Defined Functions inside and outside queries

  • Assessment section for User Defined Functions

Fixed

  • Exception thrown while generating the HTML report

  • Transformation for DECLARE statements with scalar default value

Release 1.3.0 - October 25th, 2021

SnowConvert Core 3.1.11

Added

  • Robustness on the parser for CREATE PROCEDURES

  • Parsing and basic Assessment for CREATE FUNCTION

  • Object conversion rate for each identified object.

Fixed

  • Exception that was causing a file not to be generated

  • Transformation for variable declaration inside labels

Release 1.2.1 - October 11th, 2021

SnowConvert Core 3.1.9

Added

  • Robustness on the parser for CREATE PROCEDURES

  • Transformation for modulo (%) operations in IF conditions

  • Transformation for empty statements inside Stored Procedures

Fixed

  • Transformation for double-dot qualifiers. Example:

Input

select * from db..table1

Output

select * from db.dbo.table1

  • Comment objects with missing dependencies

  • Inconsistent Total Issues value on UI vs Assessment report

  • Custom database and schema options not working in the UI

  • Disabling EWI comments generation in some cases

  • Transformation for Procedures inside Unicode literals

Release 1.2.0 - September 28th, 2021

SnowConvert Core 3.1.8

Added

  • Robustness on the parser for CREATE PROCEDURES

  • Translation for error functions such as:

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

Fixed

  • Translation for CROSS APPLY

  • Translation for NLiteral expressions inside SELECT statements

  • Translation for IDENTITY with default values

  • Translation for UPDATE statements with JOIN clauses

Release 1.1.17 - September 14th, 2021

SnowConvert Core 3.1.3

Added

  • Robustness on the parser for CREATE VIEW and CREATE PROCEDURES

  • Translation for BREAK statement.

  • Missing dependencies warning to views without their dependencies in the source code.

  • Regions for PROCEDURES helpers.

  • Warning for MASKED columns.

Fixed

  • EXISTS translation in order to use the Snowflake built-in.

Release 1.1.16 - August 31st, 2021

SnowConvert Core 3.1.1

Added

  • Robustness on the parser for CREATE TABLE , CREATE VIEW and CREATE PROCEDURES

  • Assessment Accuracy Improvements:

    • Parsing errors count on output code and issues csv file.

    • Differentiation between warnings and errors count.

    • Warnings to some transformations properly added.

  • Built-In functions translation:

    • CONVERT

    • COALESCE

    • ISNUMERIC

    • QUOTENAME

    • USER_NAME

    • SOUNDEX

    • DATEPART

    • DATENAME

    • NEWID

    • PATINDEX

    • FORMAT

    • PARSENAME

    • STUFF

    • DATABASE_PRINCIPAL_ID

  • Translation for sysname , datetimeoffset , NChar , NText , sql_variant and timestamp data types

  • Translation for computed columns

Fixed

  • Translation for identity columns with negative values.

Release 1.1.15 - August 18th, 2021

Fixed

  • The confirmation pop-up window for canceling the migration process is not displayed correctly.

Release 1.1.14 - August 16th, 2021

SnowConvert Core 3.1.0

Added

  • Assessment Accuracy Improvements.

  • Empty square brackets can now being parsed as column definition.

  • CONSTRAINT PRIMARY KEY is now being properly translated.

  • Top Level object report Generated.

  • Default Parameters in Procedures now supported.

  • Support Column names with reserved or special keywords.

  • Assignments of the EXEC helper refactored to be more accurate to the source code.

  • XML, Image, SMALLDATETIME and UNIQUEIDENTIFIER types now supported on translations.

Fixed

  • Invalid keywords are no longer kept in the table DDL.

  • Fixed StackOverflowException on MAC that caused the application to failed with error or log message.

  • Fixed error where Hexadecimal values caused errors when contained inside procedures.

Release 1.1.12 - August 4th, 2021

SnowConvert Core 3.0.22

Added

  • Better error handling for:

    • Unicode Literal failed transformations (Accurate EWI is now displayed)

  • Parser robustness for:

    • GO command

    • OPEN GLOBAL

    • CLOSE GLOBAL

    • Files starting with invalid text (Not with SQL comments or SQL grammar elements)

  • Translation for:

    • LIKE

    • NOT LIKE

Fixed

  • Warnings added for SEQUENCE not being accurately counted.

  • Inconsistencies shown in assessment information between identical runs of the tool for some workloads.

  • Exception occurring during SELECT INTO transformation.

Release 1.1.11 - July 19th, 2021

SnowConvert Core 3.0.20

Added

  • Improved Assessment Accuracy for:

    • Declare Statements in procedures.

    • If Statements.

    • Cursor Statements.

    • Merge Statements.

  • Translate statement SELECT INTO TableName .

  • Translate statements in Create Procedure:

    • Identity Column.

    • Column names with operators.

  • Disclaimer for SQL Identified objects and SQL Files conversion rate.

Fixed

  • EXECcall not being generated in the output.

  • SnowConvert conversion loop for certain store procedures.

  • Error migrating views and code being removed.

  • Translation of negative values being translated to positive values.

  • NOT EXISTS is being translated as EXISTS.

  • Inconsistencies in Assessment Accuracy conversion rate.

  • DefaultExpression should be counted as an error and affect the conversion rate.

  • MSC-ISSUE renamed to MSC-ERROR in all the reports.

Release 1.1.10 - July 6th, 2021

SnowConvert Core 3.0.16

Added

  • Robustness on the parser for CREATE TABLE , CREATE VIEW and CREATE PROCEDURES

  • Translate basic statements in CREATE PROCEDURES such as:

    • Translate BEGIN TRANSACTION statement

    • Translate COMMIT statement

    • Translate for ROLLBACK and ROLLBACK TRANSACTION statement

    • Translate THROW statement

    • Translate INSERT INTO EXEC

  • Translate Temporal Tables

  • Translate for EXECUTE Statement and N Literal

  • Translate of CREATE PROCEDURE AS OWNER

  • Translate built-in functions that have equivalence in Snowflake

  • Translate TRUNCATE Statement

  • Translate DROP TABLE statement

  • Telemetry for assessment

Release 1.1.9 - June 22nd, 2021

SnowConvert Core 3.0.13

Added

  • Robustness on the parser for CREATE TABLE , CREATE VIEW and CREATE PROCEDURES

  • Translate basic statements in CREATE PROCEDURE such as:

    • Translate EXECUTE/EXEC statement

    • Translate embedded CREATE TABLE statement

  • Translate basic predicates such as:

    • BETWEEN Predicate

    • EXISTS Predicate

    • IN Predicate

  • Translate WITH Clauses in CREATE TABLE

  • Translate Cursor DECLARE, OPEN, FETCH, CLOSE and DEALLOCATE

Release 1.1.5 - June 9th, 2021

SnowConvert Core 3.0.9

Added

  • Robustness on the parser for CREATE TABLE , CREATE VIEW and CREATE PROCEDURES

Release 1.1.3 - May 25th, 2021

SnowConvert Core 3.0.5

Added

  • Translated basic CREATE PROCEDURE

  • Translate basic statements in CREATE PROCEDURE such as:

    • DECLARE @variable

    • SET @variable

    • TRY CATCH Statement

    • IF Statement

    • While Statement

    • RETURN Statement

    • SELECT, UPDATE, INSERT, DELETE and MERGE.

  • Translate basic expressions in CREATE PROCEDURE such as:

    • IS NULL / IS NOT NULL predicate

    • BINARY Operations ( +, -, *, / )

    • Comparisons ( >,<, <=, >= )

In order to try out the newly added translation features, you can use this example code and migrate this example with SQLServer SnowConvert.

CREATE PROCEDURE Procedure1(
    @model_year SMALLINT,
    @FirstName NVARCHAR(50),
    @Age INT,
    @Balance SMALLMONEY,
    @Description VARCHAR
) AS 
BEGIN
    DECLARE @cursor_db CURSOR;
    DECLARE @database_id INT, @database_name VARCHAR(255);
    DECLARE @product_list VARCHAR(MAX) = ' ';
    DECLARE @Variable1 AS VARCHAR(100), @Variable2 AS VARCHAR(100);
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
    SET NOCOUNT ON
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    SET NOCOUNT OFF
    SET @product_list = '';
    SET @var1 += '';
    SET @var2 &= '';
    SET @var3 ^= '';
    SET @var4 |= '';
    SET @var5 /= '';
    SET @var6 %= '';
    SET @var7 *= '';
    SET @var8 -= '';
    SET @statement = 'SELECT * FROM TABLE1 WHERE COL1 = '+@param1+ ' AND COL2 = ' + @param2;

    BEGIN TRY
        IF @Age > 15
            return
        ELSE
            return 2;
        
        WHILE (@PATITO < 2)
        BEGIN
            SELECT * FROM TABLE1;
        END;

        INSERT INTO TABLE1 VALUES (1,2,3, @param1);
        DELETE dbo.Table2 FROM dbo.Table2 INNER JOIN dbo.Table1 ON (dbo.Table2.ColA = dbo.Table1.ColA) WHERE @ColA = 1;
        Update PruebaUpdate Set Col1 = 5;
    END TRY
    BEGIN CATCH
        return -1;
    END CATCH
END;
GO

Release 1.1.2 - May 14th, 2021

SnowConvert Core 3.0.3

Added

  • Translate Tables

  • Translate Views

  • Assessment Report for Tables and Views

Known issue: you may get some error in the UI if you try to migrate Procedures and Functions

Previous2023Next2021

for ALTER TABLE statements

Transformation for in Snowflake Scripting

Transformation for variable in Snowflake Scripting

Functional equivalence review (removed ) for built-in functions such as:

Transformation for clause with parenthesis.

Functional equivalence review (removed ) for built-in functions such as:

Transformation for inside User Defined Functions

Transformation for inside User Defined Functions

Transformation for function

Transformation for supported . See also MSCEWI4046

Transformation for function inside Stored Procedures

Transformation for NOW function

Hierarchy-oriented naming in the ObjectDB column of the Top-level objects report and Top-level queries report.

Transformation for

Transformation for operators

Transformation for queries getting MERGE ACTION count from inside STORED PROCEDURES

Transformation for

Transformation for inside dynamic SQL

Invalid transformation for

Transformation for function

Transformation for function

Transformation for and function

Transformation for function

Transformation for function

Transformation for with Delete statement removing duplicates

Transformation for with partition

Transformation for statements

Transformation for inside IF statements

Transformation for (@ObjectId, @DatabaseId)

Transformation for (@ObjectId, @DatabaseId)

Transformation for statements

Transformation for function

Translation for

Translation for

Translation for statement.

Translation for function with object_type argument specified.

Translation for function

Warning for not supported statement.

Translation for using DELETE , UPDATE or INSERT

Translation for SELECT INTO used in

Translation for Expressions and built-In functions calls inside procedures.

Translation for supported .

Translation for .

Warning for .

MSCEWI4048
RAISERROR
DATEFIRST
MSCEWI1046
TOP
MSCEWI1046
ABS
CEILING
CHAR
CHARINDEX
CONCAT
CONVERT
DATEPART
DAY
Common Table Expressions
BEGIN...END
NChar
SYSTEM TABLES
OBJECT_NAME
ODBC
FOR XML CLAUSE
WITH XML NAMESPACES
OPENXML
XML Datatypes
Check here for more information
INLINE TABLE-VALUED FUNCTIONS
BITWISE
OUTPUT
CURRENT_TIMESTAMP
BULK INSERT
GETDATE()
ISDATE
PATINDEX
TRY_CONVERT
TRY_CAST
STR
@@ROWCOUNT
Common Table Expressions
ROW_NUMBER
BULK INSERT
object_id
object_schema_name
object_name
WAITFOR
ERROR_SEVERITY
LABELS and GOTO
RAISERROR
ERROR_LINE
ERROR_STATE
ERROR_PROCEDURE
ERROR_NUMBER
ERROR_MESSAGE
CONTINUE
OBJECT_ID
CAST
REVERT
COMMON TABLE EXPRESSIONS
COMMON TABLE EXPRESSION
CASE
ODBC SCALAR FUNCTIONS
SELECT @LOCAL_VARIABLE
DATABASE CONSOLE COMMANDS