[CT-1689] Check exceptions

[emmyoop]

dbt-core has deprecated functions to raise exceptions in favor of directly raising the exceptions. Nothing should be broken (yet) and the functions still raise as expected but they also will log a deprecation warning (pending dbt-labs/dbt-core#6413). It would be good to resolve these deprecation messages before the 1.4 rc.

There are a lot of deprecated function so it's easier to search for dbt.exceptions and look at each callsite to determine if it's using a function or already directly raising an exception. Then replace anywhere using functions with directly raising an exception.

We can create new exceptions in dbt-core to raise or the adapters could start to own their own exceptions within the adapter code base that inherit from exceptions in dbt-core.

For examples, see dbt-labs/dbt-core#6347 that replaced all functions with raises.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue, or it will be closed in 7 days.