NO SUITABLE DRIVER FOUND - while connecting to Snowflake environment

book

Article ID: 220996

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 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

Cause

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

Environment

Release : 4.9.177 onwards

Component : Fast Data Masker

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.