Comment on page

MSCEWI4013

Computed column transformed

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]​

MSCEWI4012

MSCEWI4014

Last modified 21d ago