when we query a table from the RedShift – we can see that our server memory (60Gb) gets exhausted. And when we terminate the query execution all the memory will be freed-up. So, from this looks, we can observe that the query result is being computed on our local SAS server thus causing for significant resource consumption. ODBC-Drivers used: PostgreSQL: psqlodbc.so, libodbcpsqlS.so MySQL: libmyodbc5.so, libodbcmyS.so MySQL Unicode: libmyodbc5w.so MySQL ANSI Driver: libmyodbc5a.so
... View more
