Using the tap-sftp and the PostgreSQL target , I am encountering a problem that appears to be caused by column names in the source files that are too long for PostgreSQL. (The proximate symptom is the sync attempts to create the columns multiple times, so the ALTER TABLE crashes the process. I suspect column name length because that stands out.) This is the initial load of the data that is failing. Is there a way to rename a column so the database creates it using a different name than is present in the source file? I am using Meltano 3.7.6. Thanks in advance!

Yes - you would be able to apply stream maps in your

target-postgres

config; specifically you probably want to use __alias__.

That did the trick! Thank you!