Links

MSCEWI4011

Column sorting removed

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.