Currently using v18.104.22.16801.
Normally we use the out of the box SQL connector and it pulls data from very long running queries just fine. I am trying to switch to the generic odbc connector so I can specify the extra option on my connection string of ApplicationIntent=ReadOnly to move some of the load off of our main server onto one of the read only replicas.
I am able to connect successfully but when rebuilding the cube, it always fails after 30 seconds because of a query timeout. It is not possible to pass a query timeout as a param in the connection string, how can we update it for the generic odbc driver to work properly?
It is very similar to this question: https://support.sisense.com/hc/en-us/community/posts/360001664193-Redshift-Query-Timeout-How-to-increase-Receive-Timeout-on-the-connection
Please sign in to leave a comment.