IsValid() connection is doing a statement.execute("select 1");

[mdiskin]

It's very common as in spring boot actuator to check the db status using the isValid() method which is supposed to be a low/zero-cost option.

It looks in snowflake this is still doing a select statement and concerned that this will also keep the warehouse status as active and costing us credits.

[sfc-gh-mknister]

Hi @mdiskin , calling "select 1" doesn't require the use of a warehouse so I don't think it would affect the warehouse status.

[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.