MSCEWI4013

Computed column transformed

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

Severity

Low

Description

This warning is added when a SQL Server computed column is transformed to its Snowflake equivalent. It is added because in some cases the functional equivalence could be affected.

Code Example

Input Code:

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

Output Code:

CREATE OR REPLACE TABLE PUBLIC.TestTable (
Col1 REAL AS (CAST(ExpressionValue AS REAL) /*** MSC-WARNING - MSCEWI4013 - Computed column was transformed to its Snowflake equivalent, functional equivalence verification pending. ***/
);

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]