Timeout error

Question

Hi Team, 
 
 There was a timeout error, what this signifies? Here, we pull the data from snowflake as a batches. In the integration, we have setup to 1500 seconds. Will increasing query timeout help here?

karthikkanjerla · Accepted Answer

Hi Purvaja, 
 
 1. Is this happening intermittently or always? if its intermittent, try adding delay between every batch. Just to provide some time to clear previous connection. 
 2. Also Increasing the timeout is not a right solution as they may cause load on app, web layer, instead try to reduce the batch size of data which you are pulling, involve someone from snowflake to optimize the query/api would be better option.

Timeout error

Top Replies