Revision history [back]

The following steps can be taken to resolve the connectivity issue between Quarkus application and Snowflake:

1. Check if the Snowflake JDBC driver is added to the Quarkus application classpath. This can be done by adding the following dependency to the pom.xml file:

<dependency>
    <groupId>net.snowflake</groupId>
    <artifactId>snowflake-jdbc</artifactId>
    <version>4.15.2</version>
</dependency>

1. Ensure that the Snowflake JDBC driver version matches the Snowflake version. If not, download the latest driver version from the Snowflake website.

2. Verify the Snowflake account name, username, password, and other connection parameters are correctly set in the Quarkus application properties file. The JDBC connection URL should be in the following format:

jdbc:snowflake://<account-name>.snowflakecomputing.com/?user=<user-name>&password=<password>

1. If using a proxy server, ensure that the proxy settings are correctly configured. Add the following system properties to the Quarkus application startup command:

-Dhttps.proxyHost=<proxy-server-hostname> -Dhttps.proxyPort=<proxy-server-port>

1. Ensure that the Quarkus application has network access to the Snowflake service. If running the application on-premises, confirm if the network firewall is configured to allow outbound traffic.

2. If issue persists, check Snowflake's logs for any errors, and the application logs for any relevant information or exceptions.