Error loading CSV data from S3 to Postgres with duplicate column error

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error encountered when loading CSV data from S3 to Postgres due to duplicate column error


Question

Hi Community!
Im trying to load to Postgres16 some CSV-data from S3 bucket and i got this error after 4 unsuccessful tries:

Warning from destination: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: column “_airbyte_meta” specified more than once.
I have S3-source==4.8.4 and Postgres Destination==2.4.0

Is there any solution or workaround?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["load-csv-data", "s3-source", "postgres-destination", "duplicate-column-error"]