1

I'm getting "Error SQLExecute: out of memory for query result" while trying to load a mid level database (10s of millions records).

My Workflow is not doing anything that should cause it to store all the data in memory and the error appears to come from the Alteryx or the PostgreSQL driver.

Forbesmyester
  • 936
  • 6
  • 15

1 Answers1

1

Deep within the ODBC driver options there is an option called "Use Declare/Fetch" which you should turn on.

To get there "Configure..." your named User DSN within ODBC Sources (see start menu) then "Options" > "Datasource" and tick "Use Declare/Fetch"

Forbesmyester
  • 936
  • 6
  • 15