When trying to connect to Snowflake in SDC, you may encounter the following error:
SNOWFLAKE_11 - Could not create SQL DataSource: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Remote host terminated the handshake.
This error may be caused by some configuration mistakes in the stage. One possible cause is underscore(s) in the account name. The Snowflake JDBC driver does not support the use of underscores in URLs, which include the account name.
If your account name does contain underscores, and you are receiving a similar error, a workaround would be to use a hyphen instead.