Links

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]