SNOW-159537: SFAsyncResultSet.next makes unnecessary HTTP call to monitoring API

[buremba]

We use the async API with statement.executeAsyncQuery and poll statement.getStatus periodically. Once we have the result, we start calling resultSet.next() but I realized that the first resultSet.next() performs an unnecessary HTTP call to Snowflake monitoring API in order to see if the query is executed.

It would be great if you can cache the status for the query id in order to avoid calling the API again in resultSet.next().

[sfc-gh-mknister]

Hi @buremba , we will look into caching the value.

[sfc-gh-igarish]

To clean up and re-prioritize more pressing bugs and feature requests we are closing all issues older than 6 months as of March 1, 2023. If there are any issues or feature requests that you would like us to address, please create them according to the new templates we have created. For urgent issues, opening a support case with this link Snowflake Community is the fastest way to get a response.