[BUG] Query Bigquery with Bigquery connector

[matiastzara]

Describe the bug
I create a new connexion with biguery connector, the thing is when you try to connect the query fails.
We fix it changing the version of the connector from 2024.3.2 to 2023.49.2

Screenshots / Exceptions / Errors
This is the error

GENERIC_USER_ERROR: Encountered an exception[java.lang.NoSuchMethodError] from your
LambdaFunction[arn:aws:lambda:us-east-1:XXXXXXXXXXXXX:function:xxxxxxx] executed in
context[S3SpillLocation{bucket='xxxxxxxxxxxx', key='athena-spill/xxxxxxxxxxxxxx/xxxxxxxxxxxxxx', directory=true}]
with message['io.grpc.NameResolverProvider io.grpc.NameResolverRegistry.getProviderForScheme(java.lang.String)']

Connector Details (please complete the following information):

• This is the version I was using: applications-AthenaGoogleBigQueryConnector-versions-2024.3.2
• This is the working version: applications-AthenaGoogleBigQueryConnector-versions-2023.49.2

[matiastzara]

Also the connexion works, you can see the tables and the columns, but you can't query.

[jimmyn]

I'm having the same issue, what is the solution to this? How do I install a specific version of the connector through AWS Serverless Application Repository?

[AbelCRG]

Hi AWS-Labs, yeah it's still a problem for my business too. Please escalate it in your backlog!

[akuzin1]

The associated PR to fix the issue: #1739 will be included in next release. We are currently working on kicking off new release, we will update when it has been published.

[jimmyn]

@akuzin1 Thank you! When the new release is expected?

[akuzin1]

New release v2024.6.1 should now be available! Appreciate your patience.