Product:

StreamSets Data Collector

Issue: 

JDBC Lookup processor is not working when connecting to Snowflake. It throws an error: START_ERROR: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: null

Solution:

When using the JDBC stages, Read-Only connections are enforced by default, and it seems that the Snowflake JDBC driver doesn't support that.

Disabling that property in the JDBC Lookup stage resolved the problem. You can disable it by clicking on the stage ---> Check `Show Advanced Options` --->Advanced tab ---> Enforce Read-only Connection and uncheck it.