Reinstate removed test for Bigquery

[dave-connors-3]

As we've discussed, I think we should come back to this in a future issue -- I think if there's any way for us to avoid reducing our test coverage, we should absolutely do so. On the other hand, if this prevents the project from being executed on reasonably normal-sized projects, we should have that be the priority for now

Originally posted by @dave-connors-3 in https://github.com/dbt-labs/dbt-project-evaluator/pull/107#discussion_r879589850