NO SUITABLE DRIVER FOUND - while connecting to Snowflake environment

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Using Fast Data Masker version 4.9.177.0 to enable FDM to connect to Snowflake environment. When trying to connect to Snowflake environment, below error is getting generated - 

NO SUITABLE DRIVER FOUND FOR 
JDBC:SNOWFLAKE://HTTPS://HOSTNAME.SNOWFLAKECOMPUTING.COM/CONSOLE/LOGIN#/ 
/?DB=DBNAME&SCHEMA=SCHEMANAME
URL:JDBC:SNOWFLAKE://HTTPS://HOSTNAME.SNOWFLAKECOMPUTING.COM/CONSOLE/LOGIN#/ /?DB=DBNAME&SCHEMA=SCHEMANAME

Environment

Release : 4.9.177 onwards

Component : Fast Data Masker

Cause

This is caused due to missing client JAR required to connect with Snowflake Database

Resolution

 

In the connection dialog for Snowflake, give just hostname(HOSTNAME.SNOWFLAKECOMPUTING.COM) instead of the complete URL(HTTPS://HOSTNAME.SNOWFLAKECOMPUTING.COM/CONSOLE/LOGIN#/). 

Also make sure that "snowflake-jdbc-3.12.17.jar" client JAR from Snowflake is placed inside /FastDataMasker/lib/ folder.