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?
Discussion posts and replies are publicly visible
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.
Purvaja
A timeout error indicates a process exceeded the allowed time. Pulling data from Snowflake in batches with a 1500-second integration timeout suggests extending the query timeout could help.
I would recommend analyzing the performance of the integration process, optimizing queries if possible, and monitoring the impact of increasing the query timeout before making any adjustments.