Skip to main content
purvajab0002
Inspiring
April 19, 2024
Solved

Timeout error

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?

    karthikk538
    karthikk538Answer
    Inspiring
    April 19, 2024

    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. 

    View in thread

    2 replies

    karthikk538
    karthikk538Answer
    Inspiring
    April 19, 2024

    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. 

      manishs0028
      Known Participant
      May 3, 2024

      [mention:b76d2763698d4903be0a9d84166776d9:e9ed411860ed4f2ba0265705b8793d05] 

      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.

      Terms & ConditionsAccessibility statement