MSCEWI4011

Column sorting removed

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

Severity

Low

Description

This warning is added when a column in a table has ASC or DESC sorting specification. Since it is not allowed in Snowflake, it will be removed in the output code.

Code Example

Input Code:

CREATE TABLE "bb"."SRC"."T1"
(
  [id]  INT,
	CONSTRAINT [PK_at_ad] PRIMARY KEY ([id] ASC)
);

Output Code:

CREATE OR REPLACE TABLE "bb"."SRC"."T1" (
   id INT,
   CONSTRAINT PK_at_ad PRIMARY KEY (id /*** MSC-WARNING - MSCEWI4011 - Column sorting is not supported in Snowflake ***/)
);

Recommendations

• No additional user actions are required, it is just informative.

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