Hi guys! I have this trouble when I try to send d...
# replication-troubleshooting
i
Hi guys! I have this trouble when I try to send data from PG to SF. • Is this your first time deploying Airbyte?: No • OS Version / Instance: ec2 m6a.2xlarge. • Deployment: Docker • Airbyte Version: 0.40.26 • Source name/version: Postgres 1.0.35 • Destination name/version: Snowflake 0.4.40 • Step: My sync is failing for full refresh | append. • Description: The error message I’m getting is Cannot drop column ‘_AIRBYTE_UNIQUE_KEY’ which belongs to a clustering key. • Table size: 325GB • Note: Completed the syncs but when the normalization begin, fail and give the description message. "Normalization failed for job 35." Any ideas? I saw the community already and didn't find some useful. Thanks!
n
Hey Ignacio! Thanks for your patience - I was out last week for the holidays and am catching up with messages now. I noticed a similar thread in the forum and there was an interesting suggestion in one of the comments: https://discuss.airbyte.io/t/incremental-models-failing/2613/2?u=natalyjazzviolin Could you follow this tutorial to dig deeper into where this value is coming from? Full logs would also be helpful. Thanks!