The overall approach looks fine and is in the right direction and can be refined based on the further business requirement.

If there is a specific time based on which the data in the tables needs to be deleted, you may review the following article: https://community.snowflake.com/s/article/How-to-delete-files-older-than-a-specific-date-in-a-Snowflake-stage