Automate cleaning up the removed or renamed models

[rachellougee]

User Story

When a model is deleted or renamed from code, dbt clean doesn't automatically remove the old models from QA and Production schema so we have to manually delete it. Tobias shared https://discourse.getdbt.com/t/faq-cleaning-up-removed-models-from-your-production-schema/113/11 that we might consider writing a macro to handle the deleted models
automatically

[rachellougee]

https://docs.getdbt.com/faqs/models/removing-deleted-models
In dbt doc, it seems to suggest manually delete

When you remove models from your dbt project, you should manually drop the related relations from your schema.`

[rachellougee]

Looked at this a little bit, the proposed solutions to write a macro in this post are convoluted and require proper permission to run dbt run-operation delete_outdated_tables --args "{schema: [SCHEMA]}" command on production and qa to invoke the macro.

Since dbt suggests manually dropping the related staled model it in their doc, I will leave it the way it is. If we end up having a lot of renamed models, we can revisit it