We are connecting to Redshift database from Matillion. our jobs occassionally getting failed with error "[Amazon](600000) Error setting/closing connection: Connection reset by peer." Anyone faced this type of issues and found any work around?

we are connecting to Redshift database from Matillion. our jobs occassionally getting failed with error
Amazon Error setting/closing connection: Connection reset by peer.”
Anyone faced this type of issues and found any work around?

To clarify, we are using Matillion on AWS EC2 host and connect to Redshift. this error is happening intermittently for last few months.

Hello @avnkumar

Sorry to hear you have met this error, I would strongly recommend raising this with our support team here.

They can help diagnose what is causing this error for you.

Kind regards, Joe

Created a support case now. looking forward for a resolution. thanks