SSC-FDM-TD0007
Variant column does not support collation.
Description
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.
Example code
Input code:
CREATE TABLE TableExample
(
ColumnExample JSON(2500) NOT CASESPECIFIC
)
Output code:
CREATE OR REPLACE TABLE TableExample
(
ColumnExample VARIANT
-- NOT CASESPECIFIC /*** SSC-FDM-TD0007 - VARIANT COLUMN DOES NOT SUPPORT COLLATION ***/
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;
The data type JSON is converted to VARIANT, while NOT CASESPECIFIC is converted to a COLLATE clause.
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated