How SnowflakeConnectionPoolDataSource creates connection pooling..How to confirm whether it maintaining connection pool or not and how to set the connection pool size.

[gmungi]

SnowflakeConnectionPoolDataSource snowflakePoolDataSource = new SnowflakeConnectionPoolDataSource();

snowflakePoolDataSource.setUrl(snowflakeUrl);
snowflakePoolDataSource.setUser(properties.getProperty("user"));
snowflakePoolDataSource.setPrivateKey(encryptedPrivateKey);
snowflakePoolDataSource.setRole(properties.getProperty("role"));
snowflakePoolDataSource.setDatabaseName(properties.getProperty("db"));
snowflakePoolDataSource.setSchema(properties.getProperty("schema"));
snowflakePoolDataSource.setWarehouse(properties.getProperty("warehouse"));

[gmungi]

How to confirm whether SnowflakeConnectionPoolDataSource maintaining connection pool or not.Where do we configure the size of the connection pool and where do we see the pool of connection objects.Can you please help on this.

[sfc-gh-dszmolka]

for anyone finding this: we don't pool the connections, you'll need to implement your own or use HikariCP or other popular pool managers. Some more details here: https://stackoverflow.com/questions/62639168/is-the-underlying-snowflake-driver-pooling-the-connections-here

Closing this one out now.