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