Is this a new bug?

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

Which packages are affected?

• dbt-adapters
• dbt-tests-adapter
• dbt-athena
• dbt-athena-community
• dbt-bigquery
• dbt-postgres
• dbt-redshift
• dbt-snowflake
• dbt-spark

Current Behavior

Reading through the package's notes on integration tests in CONTRIBUTING.md states:

"Integration tests require setting up a database connection to run locally. This will vary by package; please refer to the package's CONTRIBUTING.md for more information."

But every adapter except dbt-spark only has the below sentence in their CONTRIBUTING.md files with no further documentation.

"This document covers the incremental content beyond what is contained in the repository's CONTRIBUTING.md. You are strongly encouraged to start there first if you are reading this for the first time."

Expected Behavior

Each adapter's CONTRIBUTING.md file has documentation on how to run tests as suggested in the parent repo's documentation

Steps To Reproduce

1. Read the note on integration tests in the repo's CONTRIBUTING.md
2. Navigate to an adapter except dbt-spark and find that there is no documentation on integration tests as suggested.

Relevant log output

Environment

- OS:
- Python:
- dbt-adapters:
- <adapter>:

Additional Context

No response