Find stale dbt tables

[MeltyBot]

Migrated from GitLab: https://gitlab.com/meltano/squared/-/issues/114

Originally created by @pnadolny13 on 2022-05-09 19:37:06

---

Find an existing way to handle this or build it:

• If I rename a model, the old name still exists in Snowflake until I manually delete it. This could cause issues where we reference the old version by accident. I'd rather get a message saying the table doesnt exist anymore. Maybe this is where a metrics layer would start being helpful also.
• Diff the models in the dbt project against the snowflake info schema and determine where theres stale tables left hanging around that need to be manually delete