Kafka jdbc sink connector for snowflake

I am trying to send json data from kafka topic to snowflake rdbms table using jdbc sink connector. Is it possible to do it using jdbc sink connector?

image

JDBC URL TRIED:

jdbc:snowflake://DNS;Database=DB_NAME;
Warehouse=NAME;Account=NAME;
Role=NAME

jdbc:snowflake://DNS;Database=DB_NAME&
Warehouse=NAME&Account=NAME&
Role=NAME

NOTE:

  1. WE Don’t want to use snowflake sink connector.
  2. when we are using jdbc sink connector, no snowflake driver found.
  3. tried with oracle dialect, sqlserver dialect, generic database dialect

Your quick help is highly appreciable

when we are using jdbc sink connector, no snowflake driver found

That’s a JVM classpath problem that you need to fix outside of Connect or it’s configs. You can export CLASSPATH environment variable to a path containing the Snowflake driver

If your image is Confluent Cloud, then you’ll be unable to use Snowflake with JDBC since the driver is not available.