[Tech Debt] test_dbt_debug is not dropping its test schema

[mikealfare]

Is this a new bug in dbt-bigquery?

• I believe this is a new bug in dbt-bigquery
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Schemas are building up in the CI database. The vast majority of them are for the test test_dbt_debug. There are others that may just be due to intermittent connection issues, but this is the primary concern.

Expected Behavior

Tests should always clean up their test schema, even when failing.

Steps To Reproduce

Run this query against the CI database:

SELECT RIGHT(schema_name, LENGTH(schema_name)-LENGTH('test17061864288069965012_')), count(schema_name)
FROM `dbt-test-env`.INFORMATION_SCHEMA.SCHEMATA
WHERE schema_name LIKE 'test%_test_%'
GROUP BY 1
ORDER BY 2 DESC

Relevant log output

Top 5 output from the above query:

schema stub	schemas
test_dbt_debug	4,260
test_job_timeout	97
test_utils	51
test_get_relation_last_modified	43
test_basic	35

Environment

- OS: all
- Python: all
- dbt-core: unknown
- dbt-bigquery: unknown