# Snowflake datawarehouse with Federated SSO authentication

**URL:** <https://forum.inductiveautomation.com/t/snowflake-datawarehouse-with-federated-sso-authentication/74535>\
**Category:** Ignition\
**Created:** [June 3, 2023, 9:42pm UTC](https://forum.inductiveautomation.com/t/snowflake-datawarehouse-with-federated-sso-authentication/74535 "2023-06-03T21:42:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marc.Akoto](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/marc.akoto/32/19291_2.png) [@Marc.Akoto](https://forum.inductiveautomation.com/u/Marc.Akoto)\
**Post date:** [June 3, 2023, 9:42pm UTC](https://forum.inductiveautomation.com/t/snowflake-datawarehouse-with-federated-sso-authentication/74535/1 "2023-06-03T21:42:58Z")

</div>

Hi there,  
I'm trying to configure a database connection to SnowFlake.  
My SnowFlake account uses federated SSO authentication (SAML2) with Azure ADFS.

I followed this guide [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)  
Both the JDBC Driver and the Translator for SnowFlake are already setup.  
But I'm struggling with the "Connect URL"

For now I get a "Faulted" connection status.

The snowflake documentation refers to an "authenticator=" login parameter, which should be followed by the URL endpoint for my IdP.  
[Managing/Using Federated Authentication | Snowflake Documentation](https://docs.snowflake.com/user-guide/admin-security-fed-auth-use#label-sso-with-command-line-clients)

However in the URL to my Azure ADFS IdP, a new SAMLRequest key is required for each new authentication.

For those of you who already worked with federated authentication to databases, what would you advice in this case please ?

- Does Ignition offer a simple way to manage those SAML keys in the "Connect URL" of my database connection ?
- Or is it better to create in my IdP a dedicated service account that Ignition will use to access the SnowFlake datawarehouse ?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Joshua\_Benjamin](https://avatars.discourse-cdn.com/v4/letter/j/e56c9b/32.png) [@Joshua\_Benjamin](https://forum.inductiveautomation.com/u/Joshua_Benjamin)\
**Post date:** [June 13, 2023, 9:27pm UTC](https://forum.inductiveautomation.com/t/snowflake-datawarehouse-with-federated-sso-authentication/74535/2 "2023-06-13T21:27:22Z")

</div>

Hey @Marc.Akoto,

I would recommend contacting [Support](https://support.inductiveautomation.com/hc/en-us) for this issue. There, we'll better be able to help you troubleshoot the connection status of the database.