Driver communication error with Snowflake

book

Article ID: 221460

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Using Fast Data Masker version 4.9.177.0 to enable tool to connect to Snowflake environment.

Downloaded snowflake-jdbc-3.12.17.jar file and placed it inside /FastDataMasker/lib/ folder. Getting below error when trying to connect to Snowflake environment - 

JDBC DRIVER ENCOUNTERED COMMUNICATION ERROR. MESSAGE: EXCEPTION 
ENCOUNTERED FOR HTTP REQUEST: CONNECTION 
RESET.
URL:JDBC:SNOWFLAKE://HOSTNAME.SNOWFLAKECOMPUTING.COM/?DB=DB_NAME&SCHEMA=SCHEMA_NAME

Cause

Unable to connect to Snowflake host via browser, PING and TELNET commands from the FDM machine. It explains the same issue happening from FDM tool. The issue is with Network/Firewall.

 

Environment

Release : 4.9

Component : CA Test Data Manager - Fast Data Masker

Resolution

It is required to involve network team to fix the connectivity to the snowflake instance from FDM machine via Browser, PING and TELNET commands and then try from FDM tool.

To test with TELNET, please confirm the port from Snowflake side with respect to the transport protocol in the URL. Typically, HTTPS works over 443 and 8443 ports and HTTP works on 80 and 8080 ports.