MSCEWI4012

The computed expression could not be upgraded

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

Severity

Low

Description

This warning is added when the expression of a computed column could not be transformed.

Code Example

Input Code:

CREATE TABLE [TestTable](
    [Col1] AS (CONVERT ([REAL], ExpressionValue))
);

Output Code:

CREATE OR REPLACE TABLE PUBLIC.TestTable (
Col1 REAL /*** MSC-WARNING - MSCEWI4012 - Warning type for computed column was added, but computed expression '(CONVERT ([REAL], ExpressionValue))' could not be upgraded to snowflake ***/
);

Recommendations

• No additional user actions are required, it is just informative.

• Add manual changes to the not transformed expression.

• If you need more support, you can email us at [email protected]