[Under the hood] Standardize on "Adapter Integration Tests" GitHub workflow

[dbeatty10]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-postgres functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Current

The adapter integration for most adapters maintained by dbt Labs can be found here:

https://github.com/dbt-labs/dbt-postgres/actions/workflows/integration.yml

But the ones for dbt-postgres are here instead:

https://github.com/dbt-labs/dbt-postgres/actions/workflows/integration-tests.yml

The difference is a file name of integration-tests.yml instead of integration.yml.

Proposed

The proposed feature is two-fold:

1. Rename the workflow file from integration-tests.yml to integration.yml
2. Standardize the workflow definitions so that dbt-postgres and dbt-redshift so they only differ where they need to (e.g., environment variables, etc.).

Describe alternatives you've considered

No response

Who will this benefit?

People testing a PR in dbt-adapters against each of the adapter repos maintained by dbt Labs, like here: dbt-labs/dbt-adapters#372 (comment)

Are you interested in contributing this feature?

No response

Anything else?

No response