I’m trying to run a fairly large query to build a derived table to perform some product analysis. However, when I try to run the query after about 20 minutes the connection drops out, and subsequently try to run the query again, the connection to Redshift has been cut.
I’m really not sure why this is happening. I’ve tried running this in a couple of different SQL clients with the same results. The error message I’m getting is below:
“setting/closing connection connection reset by peer”
Any help would be greatly appreciated.