snowflake-grafana-datasource icon indicating copy to clipboard operation
snowflake-grafana-datasource copied to clipboard

Snowflake query timeout

Open nparmarviasat opened this issue 1 year ago • 3 comments

Hi, My query timing out here is message "Error message request handler error: failed to query data: Failed to query data: rpc error: code = DeadlineExceeded desc = context deadline exceeded"

and i looking to configure timeout parameter for this , i don't have any-options ( i see in UI)

There is should be way configure the timeout

nparmarviasat avatar Sep 06 '24 16:09 nparmarviasat

Hi, You can add extra session configuration (see Connection Parameters) like requestTimeout or loginTimeout.

Can you please provide us some information about the query from Snowflake (kind of query, time of the query, amount of data ) ?

devnied avatar Sep 18 '24 07:09 devnied

in this screen shot i don't see any option for timeout configuration image

query : query is taking time 1-2 minutes ( we can't change on this much) and query doesn't timeout on snowflake side

nparmarviasat avatar Sep 18 '24 17:09 nparmarviasat

in the extra options field you can add all connection parameters https://pkg.go.dev/github.com/snowflakedb/gosnowflake#hdr-Connection_Parameters like requestTimeout=0

devnied avatar Sep 19 '24 06:09 devnied