Not able to create connection between Matillion and Redshift db

Hi all,

 

I'm facing connectivity issue which is described by following scenario:

Important to say is that Matillion is using using Postgresql driver, not Redshift driver, for establishing connection.

We already proven that this is not caused by Network security restrictions.

I’ve tried already to use sslmode attribute for connection, but still doesn’t work.

 

Version of postgresql RDS that matillion internally uses are different for these two Matillion instances:

Matillion 1 - uses postgresql 10.3

Matillion 3 - uses postgresql 13.4

 

Any idea what else i can check or test?

 

Any help is much appreciated.

Regards,

Tanja