Hello everyone, I have a problem with creating a table using Alteryx amazon redshift.
To better understand the problem, I'm trying to do a join between two tables that are already in amazon redshift and thus create a new table join.
The first time you make the process took almost 2 hours and me the below message appeared:
Info: Write Data In-DB (4): ODBC Driver version: 03.80
Error: Write Data In-DB (4): Error running PreSQL on "NoTable": [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I did more tests and I kept showing the same message. To see if it was a connection problem, I tried creating a table with only 50 records, succeeding within minutes of start
Then you ask the client about their ability at Amazon Redshift and they said it has enough capacity to store the new table and query when performing complex, they have managed to finish them, but 19 hours later
This is my problem, nose if I have to configure the connection otherwise in-database
Appreciate it your help and sorry diction, since I am translating with google translator
Atte
Daniel Jamet Bais
