[Feature] Align dbt-bigquery with dbt-core third party dependencies

[Dizzyobeah]

Is this your first time submitting a feature request?

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

Describe the feature

Hi,

Latest versions of Google Cloud Composer comes with agate 1.7.0 preinstalled. This prevents us from installing dbt-bigquery since the requirement is agate 1.6.3. If possible please align agate version with that of dbt-core (1.6.3-1.7.0).

Describe alternatives you've considered

Use an earlier version of Google Cloud Composer where agate 1.6.3 is installed as trying to resolve all other dependencies in a pre-built solution is not to recommend.

Who will this benefit?

Everyone using Google Cloud Composer and need to run later versions.

Are you interested in contributing this feature?

No response

Anything else?

https://cloud.google.com/composer/docs/concepts/versioning/composer-versions

[dbeatty10]

Thanks for reporting this @Dizzyobeah !

dbt-bigquery got its own agate dependency added in https://github.com/dbt-labs/dbt-bigquery/pull/458, but I'm not sure why.

We could try deleting this line and see if it passes CI: https://github.com/dbt-labs/dbt-bigquery/blob/f717e83927e5ac71c4a085985ecc95e7c0c70099/setup.py#L81

[github-actions[bot]]

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 comment on the issue or else it will be closed in 7 days.

[github-actions[bot]]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.