COMPUTED COLUMN
The computed expression could not be transformed.
Description
The expression of a computed column could not be transformed.
Code Example
Input Code:
CREATE TABLE [TestTable](
[Col1] AS (CONVERT ([REAL], ExpressionValue))
);
Output Code:
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
SSC-FDM-TS0014: Computed column transformed.
Last updated