Snowflake does not have a PURGE clause inside the DROP TABLE statement
This warning is added when the PURGE clause is used inside the DROP TABLE. There is no equal clause available in Snowflake for PURGE, thus removing it from the statement.
DROP TABLE table1 PURGE;
/*** MSC-WARNING - MSCEWI3084 - PURGE REMOVED FROM DROP TABLE STATEMENT. ***/
DROP TABLE PUBLIC.table1;