MSCEWI4014
With partitions clause in a truncate statement is not supported
Medium
This EWI is added when SnowConvert finds a TRUNCATE TABLE statement that contains a WITH PARTITIONS clause.
WITH PARTITIONS is not supported in Snowflake, and the behavior of TRUNCATE TABLE without it is not the intended behavior that the original code had. For this reason, the entire TRUNCATE TABLE statement is commented out.
TRUNCATE TABLE TABLE2 WITH ( PARTITIONS ($PARTITION.SomeNumberRange(@SomeNumber)) );
/*** MSC-ERROR - MSCEWI4014 - WITH PARTITIONS CLAUSE IN TRUNCATE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE. ***/
/*TRUNCATE TABLE TABLE2 WITH ( PARTITIONS ($PARTITION.SomeNumberRange(@SomeNumber)) )*/
- 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.
Last modified 1yr ago