Introduction
This article provides troubleshooting steps to resolve connection issues with your Snowflake Database. There are multiple reasons why a connection to a Snowflake database might not work. Please see the links below, and if you are still having trouble, please contact Safe Support
Account Name in the Database Connection
A common mistake is using an incorrect account name. Check out this Snowflake documentation to ensure you are using the correct account name.
Preliminary Connectivity Testing
Here is a great Snowflake network connectivity diagnostics tool, SnowCD. This should be used to confirm there are no preexisting connection issues outside of FME.
HTTP Request Errors
Please make sure to connect with your IT Team and have them review the OCSP for Snowflake Certificates using the following Snowflake documentation: OCSP Configuration.
Reader Timeout
Complex SELECT queries may cause a timeout when used in a WHERE clause or with the SQLCreator or SQLExecutor Transformer. Timeout error messages may not be clear, so setting the Snowflake Reader timeout = 0 (no timeout) might resolve some issues.