BigQuery destination using GCS staging broken in version 1.1.9 of the BigQuery Destination

Troubleshooting
#1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Debian 11
  • Memory / Disk: 8Gb / 200 GB
  • Deployment: Docker
  • Airbyte Version: Version: 0.39.17-alpha
  • Source name/version: -
  • Destination name/version: BigQuery (1.1.9)
  • Step: Add a BigQuery destination using GCS staging
  • Description:

After upgrading to latest version of the BigQuery destination, the connection test fails for BigQuery destinations with GCS staging:

"The connection tests failed.

Verification error(s) occurred for CHECK. Errors: [$.loading_method.method: must be a constant value Standard]"

Standard Inserts still works.

#2

Current solution for this is to roll back to v. 1.1.8

#3

Hey could you share the complete logs for the new sync. Also if possible upgrade it to the latest 1.1.10 and check if that is working fine

#4

It seems 1.1.10 has not been released yet? I will check when it shows up in Airbyte.

I attached the server log from today after trying to do a connection test with 1.19 - not sure if this is the actual log you are requesting?

server-logs_230622.txt (60.1 KB)

#5

It works again in 1.1.11

#6

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.

#7