Suggestions for running DBT unit tests in an isolated fashion

[ajsquared]

trafficstars

My team is excited to try out the new unit testing functionality in DBT 1.8.0. However, this does still require connecting to Databricks to run the unit tests.

We'd like to run the DBT unit tests in CI, but prefer to keep CI isolated from external services.

Do you have any suggestions for a good way to still run the DBT unit tests without actually connecting to Databricks?

I was considering using a sqlite target, but that wouldn't work for any models that use Spark/Databricks SQL specific features.