Answer: REMOVE

The REMOVE command is specifically designed to delete files from Snowflake stages (user stages, table stages, or named stages) when they are no longer needed. This is explicitly documented in Snowflake's SQL reference and confirmed by the community discussion with 100% consensus. DELETE and DROP are used for database objects like tables and schemas, not staged files. TRUNCATE TABLE removes all rows from a table but doesn't affect staged files. The community discussion correctly identifies REMOVE as the proper command for this purpose, citing official Snowflake documentation that states staged files can be removed using the REMOVE command after load operations are complete.

Author: LeetQuiz Editorial Team