3 Replies Latest reply on Mar 13, 2017 2:00 PM by Sharad Adhikari

    How to Solve Extract Timeout Issue from views in redshift

    Alex Xu

      Hi,

       

      I was trying to extract a view from redshift instead of lively connect to it. But the extract always failed after 30-40 mins.

       

      The query (view) was slow and the result of the query is about 1.4 million rows * 6 columns. (We won't be able to optimizing this view recently)

      Connecting to it lively in tableau will make the and dashboard very slow. that's why we want to do an extract then build the dashboards based on that. But we could never really create an extract because it kept time out before finish.

       

      Is there any way to change the timeout limit to a longer period? or any other way to solve this issue?

       

      Thanks,

      Alex