# Kafka jdbc sink connector for snowflake

**URL:** <https://forum.confluent.io/t/kafka-jdbc-sink-connector-for-snowflake/6590>\
**Category:** Kafka Connect\
**Created:** [23 November 2022 13:11 UTC](https://forum.confluent.io/t/kafka-jdbc-sink-connector-for-snowflake/6590 "2022-11-23T13:11:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ranjan](https://avatars.discourse-cdn.com/v4/letter/r/35a633/32.png) [@ranjan](https://forum.confluent.io/u/ranjan)\
**Post date:** [23 November 2022 13:11 UTC](https://forum.confluent.io/t/kafka-jdbc-sink-connector-for-snowflake/6590/1 "2022-11-23T13:11:16Z")

</div>

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](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/e/e984efabce18ba7636604264cd06b1bfa20ce620.png)

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

---

<div class="post-metadata">

**Author:** ![OneCricketeer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/onecricketeer/32/1551_2.png) [@OneCricketeer](https://forum.confluent.io/u/OneCricketeer)\
**Post date:** [24 November 2022 04:30 UTC](https://forum.confluent.io/t/kafka-jdbc-sink-connector-for-snowflake/6590/2 "2022-11-24T04:30:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [24 December 2022 04:30 UTC](https://forum.confluent.io/t/kafka-jdbc-sink-connector-for-snowflake/6590/3 "2022-12-24T04:30:44Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.