title: How to use HikariPool to connect to Snowflake - SpringBoot, Gradle
body: <p>I am trying to connect to <code>Snowflake</code> using <code>HikariPool</code>. I am using <code>SpringBoot</code> and <code>Gradle</code>.</p>
  <p>I added these dependencies to Gradle</p>
  <pre><code>implementation group: 'org.springframework.boot', name: 'spring-boot-starter-jdbc'
  implementation 'net.snowflake:snowflake-jdbc:3.12.16'
  implementation group: 'com.zaxxer', name: 'HikariCP', version: '5.0.0'
  </code></pre>
  <p>And config file looks like this:</p>
  <pre><code>@Slf4j
  @Configuration
  public class SnowflakeRepositoryConfig {
  
      @Bean
      JdbcTemplate jdbcTemplate(@Value(&quot;${repository.snowflake.url}&quot;) String jdbcUrl,
                                @Value(&quot;${repository.snowflake.user}&quot;) String user,
                                @Value(&quot;${repository.snowflake.password}&quot;) String password){
          
          log.info(&quot;-----Configuring JDBCTemplate------&quot;);
          HikariConfig config = new HikariConfig();
          config.setDriverClassName(&quot;net.snowflake.client.jdbc.SnowflakeDriver&quot;);
          config.setJdbcUrl(jdbcUrl);
          config.setUsername(user);
          config.setPassword(password);
          HikariDataSource ds = new HikariDataSource(config);
  
          return new JdbcTemplate(ds);
      }
  }
  </code></pre>
  <p><strong>Application.yml</strong></p>
  <pre><code>repository:
    snowflake:
      url: jdbc:snowflake://nw99383.eu-west-2.snowflakecomputing.com/?db=TEST_DB&amp;warehouse=SF_TUTS_WH&amp;schema=PUBLIC&amp;tracing=ALL
      user: ****
      password: ****
  </code></pre>
  <p>And I am getting following error:</p>
  <pre><code>13:56:42.353 [main] ERROR net.snowflake.client.core.HttpUtil - Response status line reason: Forbidden
  13:56:42.358 [main] ERROR net.snowflake.client.core.HttpUtil - Response content: &lt;html&gt;
  &lt;head&gt;&lt;title&gt;403 Forbidden&lt;/title&gt;&lt;/head&gt;
  &lt;body&gt;
  &lt;center&gt;&lt;h1&gt;403 Forbidden&lt;/h1&gt;&lt;/center&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  
  13:56:43.371 [main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
  net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: HTTP status=403.
  </code></pre>