I have to implement a data load scenario as below using snowflake dynamic table

1. create stage table 1 by joining source table set1
2. create stage table 2 by joining source tables set2
3. check if target table has source records where record type is external , if such records exists delete those records
4. load data available in stage table 2 to target table

Please let me know how to handle this load scenario using snowflake dynamic table

not able to implement this scenario using snowflake dynamic table