COMPUTED COLUMN

The computed expression could not be transformed.

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)) !!!RESOLVE EWI!!! /*** SSC-EWI-TS0013 - 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-EWI-TS0013: Computed column transformed.