[CT-904] Add test integration test for BigQuery-specific adapter_response contents

[McKnight-42]

Describe the feature

a BigQuery specific set of integration/functional tests to check the adapter response contents would be great to double check build of contents and verify new feature adds such as

• Add slot_ms to BigQueryAdapterResponse #195
• Provide jobIds behind model creation in run_results.json #92

Who will this benefit?

users/maintainers will all have viable ways to trust the bigquery adapter_response

[jtcohen6]

Thanks for opening @McKnight-42!

I added a test to dbt-snowflake that does something similar, by inspecting the results object to ensure the expected value of adapter_response["rows_affected"]: https://github.com/dbt-labs/dbt-snowflake/blob/main/tests/functional/adapter/test_incremental_run_result.py

[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.