Alteryx disconnecting from Postrges DBMS

Question

Hi, We are running Alteryx against our Yellowbrick data warehouse (postgres).  When trying to extract a large dataset (28 million rows / very wide).  We are loosing connection to the Database.  The query has run and is in the process of fetching rows. I have the ODBC driver set for Declare/fetch and the batch size is at 10,000.

The workflow is a simple query, then we stream it out and write it to a file on a drive thats physically mounted to the alteryx server

The time and amount of rows that are read and fetched by Alteryx varies from a few hundred thousand all the way to 15 million before it terminates the connection.

This is the error we see on the Alteryx server.  We don't see any errors in the postgres logs on the DBMS platform

Error SQLExtendedFetch: server closed the connection unexpectedly

Any ideas?

thanks

gabrielvilella · Answer

It is hard to say exactly what is the issue here, it seems that the connection is being terminated because it’s taking too long. But the question I have is, do you really need to download all that data? Alteryx has In-DB tools where you can process the data in the database server, rather than downloading everything to your local machine.