SELECT CONCAT('DROP TABLE ', table_name, ' ;')                                                      
FROM your_database_name.information_schema.tables                                                   
WHERE table_name like '%_STAGING';  

-- 1) Then, click “COPY” to get the TSV results.
-- 2) Paste all those commands to a Snowflake worksheet
-- 3) Review carefully
-- 4) Select all DELETE queries and execute the query