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