Troubleshooting
Problem
Networking issues between the client (the Snowflake stage) and the server (the Snowflake endpoint).
The HTTP response HTTP status=504 means Gateway Timeout trying to connect Snowflake. This issue usually happens when the SDC engine has a proxy configured.
Symptom
Running a job with a Snowflake stage in an SDC engine, the job can run successfully many executions but in one execution the following error arises:
SNOWFLAKE_11 - Could not create SQL DataSource: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: JDBC driver encountered communication error. Message: HTTP status=504
Reviewing the sdc.log, you can see connection issues trying to reach Snowflake, the petition POST https://youraccount.privatelink.snowflakecomputing.com:443/session/v1/ gets a response 504.
Resolving The Problem
This issue can happen because of a networking problem or a high latency in the transmission of data packets between the SDC engine and the Snowflake endpoint.
Increase the Snowflake parameter login timeout in the configuration of the Snowflake stage:
Go to the Snowflake Connection Info tab.
In the Connection Properties field set the key
loginTimeoutand a value in seconds. For example:120.
If the issue persists, please, contact Technical Support for more help.
For more information, you can access our Documentation:
Configuring a Snowflake Destination
And visit also the Snowflake Documentation for more details on the connection parameters:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-parameters#logintimeout)
Document Location
Worldwide
Was this topic helpful?
Document Information
More support for:
IBM StreamSets Data Collector
Software version:
All Version(s)
Document number:
7186255
Modified date:
15 March 2025
UID
ibm17186255