Step 8. Remove the Successfully Loaded Data Files

Execute REMOVE to remove any data files from the internal stage that you loaded successfully. In regular use, removing data files you’ve loaded and verified saves you data storage.

REMOVE @my_csv_stage PATTERN='.*.csv.gz';

Snowflake returns the following results:

+-------------------------------+---------+
| name                          | result  |
|-------------------------------+---------|
| my_csv_stage/contacts1.csv.gz | removed |
| my_csv_stage/contacts4.csv.gz | removed |
| my_csv_stage/contacts2.csv.gz | removed |
| my_csv_stage/contacts3.csv.gz | removed |
| my_csv_stage/contacts5.csv.gz | removed |
+-------------------------------+---------+
REMOVE @my_json_stage PATTERN='.*.json.gz';

Snowflake returns the following results:

+--------------------------------+---------+
| name                           | result  |
|--------------------------------+---------|
| my_json_stage/contacts.json.gz | removed |
+--------------------------------+---------+

Next: Step 9. Congratulations!