[CT-1043] Support google-cloud-bigquery 3.x.x dependency

[whittid4]

Describe the feature

dbt-bigquery requires a version of google-cloud-bigquery that is less than 3, but I have another dependency that has a minimum requirement of 3.2.0 and causing a conflict

dbt-bigquery (>=1.2.0,<2.0.0) requires google-cloud-bigquery (>=1.25.0,<3)

Describe alternatives you've considered

No alternatives considered apart from not upgrading other dependencies that require google-cloud-bigquery

Who will this benefit?

Anyone using dbt-bigquery along with other dependencies that require bigquery

Are you interested in contributing this feature?

I would be happy to contribute to this unless there is a reason why the version has been pinned

[dbeatty10]

@whittid4 thanks for opening and we'd welcome a PR for this!

I think this is the last time the upper bounds were adjusted (before this adapter was migrated from dbt-core into its own dbt-bigquery repo):

• Update google cloud dependencies dbt-core#3156

Based on the discussion there, we'd welcome relaxing the upper bounds further:

• I didn't see any known incompatibilities discussed there.
• The upper bound of <3 for google-cloud-bigquery was merged on 2021-04-02, but google-cloud-bigquery 3.0.0 wasn't released until almost exactly a year later.

So this looks like an upper bound to protect against "unknowns" rather than "knowns".

Acceptance criteria:

• If all the tests pass after you relax the relevant upper bounds, then we should be clear for takeoff ✈️

[whittid4]

Thanks @dbeatty10, I will have a read through the contributing guide as I have not contributed to this repo before and try and get a PR up

[essp-lbg]

@whittid4 I would to have a go at this issue. first time contributor. would it be dependency change to allow 3.2.0? can guidance much appreciated

[d-casal]

@dbeatty10 Hi Doug, one of our engineers (eplus-aolalere) submitted a PR for this issue. Would you (or another maintainer on the team) be able to review the PR and see if it can progress? Thank you