Error Loading CSV Data to Postgres from S3

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

Summary

User encounters a RuntimeException related to duplicate column ‘_airbyte_meta’ while loading CSV data from S3 to Postgres 16. The versions in use are S3-source 4.8.4 and Postgres Destination 2.4.0.


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

['postgres', 's3', 'csv-data', 'airbyte-meta', 'runtime-exception']