MSCEWI4003

Encrypted with not supported in Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning is added when there is an ENCRYPTED WITH used in a Column Definition. Since this is not supported in Snowflake, it is being removed and a warning is added.

Code Example

Input Code:

CREATE TABLE [SCHEMA1].[TABLE1] (
    [COL1] NVARCHAR(60)
        ENCRYPTED WITH (
            COLUMN_ENCRYPTION_KEY = MyCEK,
            ENCRYPTION_TYPE = RANDOMIZED,
            ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256'
        )
);

Output Code:

CREATE TABLE "SCHEMA1"."TABLE1" (
"COL1" NVARCHAR(60)
-- ** MSC-WARNING - MSCEWI4003 - ENCRYPTED WITH NOT SUPPORTED IN SNOWFLAKE **
--ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY EQUALS MyCEK,
--ENCRYPTION_TYPE EQUALS RANDOMIZED, ALGORITHM EQUALS 'AEAD_AES_256_CBC_HMAC_SHA_256'
--)
);

Recommendations

• No additional user actions are required.

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