# Snowflake database connection

**URL:** <https://forum.inductiveautomation.com/t/snowflake-database-connection/92890>\
**Category:** Ignition\
**Tags:** database, perspective\
**Created:** [July 8, 2024, 12:01pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890 "2024-07-08T12:01:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![a\_kodle](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@a\_kodle](https://forum.inductiveautomation.com/u/a_kodle)\
**Post date:** [July 8, 2024, 12:01pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/1 "2024-07-08T12:01:53Z")

</div>

Hi , I wanted to connect to snowflake database with ignition and also login through SSO authentication. Can anyone suggest me how to do it??

I have already referred to the other links and configured the driver and the translator, now stuck on the connection part.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 8, 2024, 12:34pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/2 "2024-07-08T12:34:09Z")

</div>

Ignition makes database connections from the gateway, not from a client, so SSO isn't applicable. All Ignition clients will use the same database credentials, as it will be the gateway making a persistent database connection.

---

<div class="post-metadata">

**Author:** ![a\_kodle](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@a\_kodle](https://forum.inductiveautomation.com/u/a_kodle)\
**Post date:** [July 9, 2024, 9:42am UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/3 "2024-07-09T09:42:27Z")

</div>

i have followed the steps mentioned in this post([https://support.inductiveautomation.com/hc/en-us/articles/4408715117197-Creating-database-connections-with-custom-translators-and-3rd-party-JDBC-drivers](https://support.inductiveautomation.com/hc/en-us/articles/4408715117197-Creating-database-connections-with-custom-translators-and-3rd-party-JDBC-drivers))

But im getting this error can you help me why im getting this ?  
Cannot create PoolableConnectionFactory (JDBC driver encountered communication error. Message: No trusted certificate found.)

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [July 9, 2024, 12:48pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/4 "2024-07-09T12:48:51Z")

</div>

> [@a\_kodle](#):
>
> Message: No trusted certificate found

Sounds like a certificate issue with your database connection.

A quick google search renders this: [Snowflake Community](https://community.snowflake.com/s/article/JDBC-connection-fails-with-No-trusted-certificate-found)

---

<div class="post-metadata">

**Author:** ![a\_kodle](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@a\_kodle](https://forum.inductiveautomation.com/u/a_kodle)\
**Post date:** [July 17, 2024, 6:00am UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/5 "2024-07-17T06:00:52Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/3/6374d4ab4f83fadff850932e75fccea250215b8e.png)  
I tried everything but i dont know why the connection status is stuck at reconnecting.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 17, 2024, 12:01pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/6 "2024-07-17T12:01:16Z")

</div>

There should be log entries corresponding to each failed connection attempt.

---

<div class="post-metadata">

**Author:** ![a\_kodle](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@a\_kodle](https://forum.inductiveautomation.com/u/a_kodle)\
**Post date:** [July 17, 2024, 12:21pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/7 "2024-07-17T12:21:12Z")

</div>

I checked in the logs , there is no record of any error.  
plus the connection status is not turning to error as well its just in reconnecting status.

Could it be related to firewall issue?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 17, 2024, 12:23pm UTC](https://forum.inductiveautomation.com/t/snowflake-database-connection/92890/8 "2024-07-17T12:23:19Z")

</div>

Of course a firewall could be the problem. Or some IT security proxy that is messing with certificates. You need someone looking over your shoulder. IA support can do that.