You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My python code uses pandas gbq's to_gbq function to write to the big query table. It works as expected when running the code. But when I use bigquery emulator in unit test, it throws the below error
GenericGBQException("Reason: {0}".format(ex)) from ex
pandas_gbq.exceptions.GenericGBQException: Reason: 400 POST http://localhost:9050/bigquery/v2/projects/local-project/jobs?prettyPrint=false: unspecified job configuration query
What did you expect to happen?
I expected the to_gbq function to write the data to the bigquery emulator table
How can we reproduce it (as minimally and precisely as possible)?
I am using the function as below
from pandas_gbq import to_gbq
to_gbq(df, destination_table=f"{dataset_id}.{table_name}", project_id=project_id, if_exists='append')
Created the dataset & table for the bigquery emulator. Testing the code in the unit test, but getting the below error
GenericGBQException("Reason: {0}".format(ex)) from ex
pandas_gbq.exceptions.GenericGBQException: Reason: 400 POST http://localhost:9050/bigquery/v2/projects/local-project/jobs?prettyPrint=false: unspecified job configuration query
Anything else we need to know?
No response
The text was updated successfully, but these errors were encountered:
Testing the above with bigquery emulator results in error
GenericGBQException("Reason: {0}".format(ex)) from ex
pandas_gbq.exceptions.GenericGBQException: Reason: 400 POST http://localhost:9050/bigquery/v2/projects/local-project/jobs?prettyPrint=false: unspecified job configuration query
jitendrawbd
changed the title
Does this work with Pandas GBQ?
Does the emulator work with Pandas GBQ?
Apr 3, 2024
What happened?
My python code uses pandas gbq's
to_gbq
function to write to the big query table. It works as expected when running the code. But when I use bigquery emulator in unit test, it throws the below errorWhat did you expect to happen?
I expected the
to_gbq
function to write the data to the bigquery emulator tableHow can we reproduce it (as minimally and precisely as possible)?
I am using the function as below
Created the dataset & table for the bigquery emulator. Testing the code in the unit test, but getting the below error
Anything else we need to know?
No response
The text was updated successfully, but these errors were encountered: