COMPUTED COLUMN

The computed expression could not be transformed.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

The expression of a computed column could not be transformed.

Code Example

Input Code:

IN -> SqlServer_01.sql

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

Output Code:

OUT -> SqlServer_01.sql

CREATE OR REPLACE TABLE TestTable (
    Col1 REAL AS (CAST(ExpressionValue AS REAL)) /*** SSC-FDM-TS0014 - COMPUTED COLUMN WAS TRANSFORMED TO ITS SNOWFLAKE EQUIVALENT, FUNCTIONAL EQUIVALENCE VERIFICATION PENDING. ***/
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
;

Recommendations

• Add manual changes to the not-transformed expression.

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

Related EWIs

1. SSC-FDM-TS0014: Computed column transformed.