This warning is added when there is a Constraint constraintName used in a default expression of a Column Definition. Since Constraint constraintName is not supported en Snowflake, it is removed and a warning is added.
CREATE TABLE [SCHEMA1].[TABLE1] ([COL1] VARCHAR (10) CONSTRAINT [constraintName] DEFAULT ('0') NOT NULL);
CREATE TABLE "SCHEMA1"."TABLE1" ("COL1" VARCHAR (10) /*** MSC-WARNING - MSCEWI4002 - CONSTRAINT IN DEFAULT EXPRESSION NOT SUPPORTED ***/DEFAULT ('0') NOT NULL);
No additional user actions required.