You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "amoeba (via GitHub)" <gi...@apache.org> on 2025/09/25 18:58:28 UTC
[I] BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given [arrow-adbc]
amoeba opened a new issue, #3487:
URL: https://github.com/apache/arrow-adbc/issues/3487
### What happened?
This may be chalked up to BigQuery being BigQuery but if you specify a project ID and use any characters they don't allow, you get a misleading error,
```
adbc_driver_manager.ProgrammingError: INVALID_ARGUMENT: [bq] Could not create session: 400 Bad Request: The project example has not enabled BigQuery.
```
With 1.8.0, I can reproduce this with,
```python
with dbapi.connect(
driver="bigquery",
db_kwargs={
"adbc.bigquery.sql.project_id": "example_"
}
```
and resolve it by removing the `_`:
```python
with dbapi.connect(
driver="bigquery",
db_kwargs={
"adbc.bigquery.sql.project_id": "example"
}
```
### Stack Trace
_No response_
### How can we reproduce the bug?
_No response_
### Environment/Setup
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given [arrow-adbc]
Posted by "amoeba (via GitHub)" <gi...@apache.org>.
amoeba commented on issue #3487:
URL: https://github.com/apache/arrow-adbc/issues/3487#issuecomment-3339700663
Whoops, I copied the wrong error and didn't notice. I've updated the original bug. It's,
> adbc_driver_manager.ProgrammingError: INVALID_ARGUMENT: [bq] Could not create session: 400 Bad Request: ProjectId must be non-empty
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given [arrow-adbc]
Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm commented on issue #3487:
URL: https://github.com/apache/arrow-adbc/issues/3487#issuecomment-3336464911
I don't see the string in the title in the example error given.
Also this is probably up to BigQuery because I think that message comes straight from them.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given [arrow-adbc]
Posted by "amoeba (via GitHub)" <gi...@apache.org>.
amoeba commented on issue #3487:
URL: https://github.com/apache/arrow-adbc/issues/3487#issuecomment-3339720903
Hrm, this is even higher up the stack. Here's the request which shows the underlying driver propagates my input verbatim:
```json
{
"configuration": {
"query": {
"createSession": true,
"defaultDataset": {
"datasetId": "bigquery-public-data",
"projectId": "my_example"
},
"query": "SELECT 1",
"useLegacySql": false
}
},
"jobReference": {
"jobId": "x1dHEASM9kIthKxW0aFBAyUczvs",
"projectId": "my_example"
}
}
```
And the response indicates it's actually their backend that has the bug:
```json
{
"error": {
"code": 400,
"message": "ProjectId must be non-empty",
"errors": [
{
"message": "ProjectId must be non-empty",
"domain": "global",
"reason": "badRequest"
}
],
"status": "INVALID_ARGUMENT"
}
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given [arrow-adbc]
Posted by "amoeba (via GitHub)" <gi...@apache.org>.
amoeba closed issue #3487: BigQuery driver fails with "ProjectId must be non-empty" when invalid project ID is given
URL: https://github.com/apache/arrow-adbc/issues/3487
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org