Bigquery Cannot replace a table with a different partitioning spec

  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: GKE 1.22.8-gke.202
  • Memory / Disk: 30GB
  • Deployment: Kubernetes
  • Airbyte Version: What version are you using now?
  • Source name/version: Postgres 1.0.2
  • Destination name/version: Bigquery 1.1.14
  • Step: Issue happening on subsequent syncs
  • Description: Getting the following error on subsequent syncs

Cannot replace a table with a different partitioning spec. Instead, DROP the table, and then recreate it. New partitioning spec is interval(type:day,field:_airbyte_emitted_at) clustering(_airbyte_unique_key,_airbyte_emitted_at) and existing spec is interval(type:day,field:_airbyte_emitted_at) clustering(_airbyte_emitted_at)

Checking the table in Bigquery yields
Screen Shot 2022-08-13 at 10.58.01 PM

Can you give more context about what you’re trying to achieve or your use case @kempspo ?