How can staged files be removed during data loading once the files have loaded successfully?

To remove staged files during data loading after they have been successfully loaded, thePURGEcopy option is used in Snowflake.

PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table.

Usage:

FROM @my_stage

FILE_FORMAT = (type = 'csv')

PURGE = TRUE;