we have couple of data sources created on Greenplum DB using generic Postgres drivers. As Postgres creating cursors we have recreated/mapped all the datasources to use Pivotal GP connection class. Some of them running fine but few extracts are timing out in Tableau. When we switch them back to Postgres, they are running fine. Any suggestions to get rid of this issue with Pivotal drivers?
We have fixed the issue by removing the custom SQL and loaded everything in the back end table. it is strange and the exact cause is unknown but it fixed our issue.