Fixing failing tests from newer dbt versions

[benc-db]

Description

This is the minimal PR required to get 1.8.x tests to stop failing due to dbt-core 1.9.0-b1 and friends.

Checklist

• [x] I have run this code in development and it appears to resolve the stated issue
• [x] This PR includes tests, or tests are not required/relevant for this PR
• [ ] I have updated the CHANGELOG.md and added information about my change to the "dbt-databricks next" section.