Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery 400 Error - If default_project ID is set, it must be equal to default_dataset's project ID

ab9801
New Member

Hello,

I have been using Simba JDBC version 1.5.0 to connect to BigQuery. From March 27th of this year (2025), I started getting this error:

{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "message": "If default_project ID is set, it must be equal to default_dataset's project ID",      "reason": "invalid"
    }],
 "message": "If default_project ID is set, it must be equal to default_dataset's project ID",  "status": "INVALID_ARGUMENT"
}.

I was using these properties: DefaultDataset="<dataset>", ProjectId="<projectid>", and QueryProperties="dataset_project_id=<pid>"

I have double checked the values and they seem to be right, in fact this connection was working for more than a year until it suddenly stopped.

From what i can gauge, the issue is that since I am mentioning just the table name in the query - select * from <table_name> dc

It is unable to get the proper dataset and project ID for this table. However, if I remove the "DefaultDataset" property, and mention the query explicitly like below:
select * from <dataset_project_id>.<dataset>.<table_name> dc

Then it is working. So it seems like it is not respecting the DefaultDataSet anymore.

Please help me in figuring out how to fix this issue, any potential trial and error things I could try. 

Thanks.

 

0 0 20
0 REPLIES 0