OSO dataset cleaner

[ravenac95]

Describe the feature you'd like to request

Currently, when things are removed from the models, we don't have a job that removes those views/tables from the dataset. We should clean anything that is no longer tracked in dbt. This will also mean that we need to move any source tables (from cloudquery or other kinds of data collection methods) into datasets that are not oso.

Describe the solution you'd like

We should have something that periodically cleans the models in the oso dataset.

Describe alternatives you've considered

N/A

[davidgasquez]

I remember doing something like this in my previous setup!

You can run a macro to clean models not present in dbt.

https://discourse.getdbt.com/t/clean-your-warehouse-of-old-and-deprecated-models/1547/16

There was also a package which had a dbt-something ls --outdated or similar but can't find right now.