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

  • 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.

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

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

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)

It works again in 1.1.11

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.