This message is shown when SnowConvert a Variant data type in the transformation of a code has a COLLATE clause. Since COLLATE is not supported with the data type VARIANT, it will be removed and a message will be added.
CREATE TABLE TableExample(ColumnExample JSON(2500) NOT CASESPECIFIC)
CREATE TABLE PUBLIC.TableExample(ColumnExample VARIANT /*** MSC-WARNING - MSCEWI2018 - VARIANT COLUMN DOES NOT SUPPORT COLLATION ***/);
The data type JSON is converted to VARIANT, while NOT CASESPECIFIC is converted to a COLLATE clause.
Because if this scenario, since VARIANT does not support COLLATE, it is removed.
No additional user actions are required.