- 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