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
This is caused due to missing client JAR required to connect with Snowflake Database
Release : 4.9.177 onwards
Component : Fast Data Masker
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.