Ask Your Question
0

How can the connectivity issue between Quarkus application and Snowflake be resolved?

asked 2021-06-02 11:00:00 +0000

qstack gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2022-06-18 03:00:00 +0000

ladyg gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-06-02 11:00:00 +0000

Seen: 9 times

Last updated: Jun 18 '22