👋 I'm trying to get

target-redshift

to work. I'm running the meltano pipeline via docker. I run the following command

meltano-docker run tap-csv target-redshift

(note meltano-docker is an alias) and get the following error:

redshift_connector.error.InterfaceError: {'S': 'FATAL', 'C': '28000', 'M': 'no pg_hba.conf entry for host "::ffff:some.ip.address.1", user "some_user", database "test_db", SSL off', 'F': '/opt/brazil-pkg-cache/packages/RedshiftPADB/RedshiftPADB-1.0.17891.0/AL2_x86_64/generic-flavor/src/src/pg/src/backend/libpq/auth.c', 'L': '477', 'R': 'ClientAuthentication'}

I was able to connect to redshift inside the docker container so not sure why target-redshift is getting an error. this is my ssl config in melatno.yml

ssl_enable: false
          ssl_mode: disable

how can I get over this error? I thought disabling ssl would do it but still get the same error

It seems similar to https://github.com/TicketSwap/target-redshift/issues/127, but that was fixed a while ago.

Thanks Edgar. It seems that the correct settings was ssl_eanble true with ssl_mode set to require. This is working for me now. The reason I went to false initially is because I kept reading that if you don't want authentication, ssl_enable should be set to false.