Has anyone successfully connected to Snowflake using OAuth? We have been using a local account to connect to Snowflake but have recently been requested to use an Azure based OAuth connection. We have an assigned client ID, key and refresh url available but need to understand how to make the calls. Thanks!
Question
Use Azure based OAuth connection to connect to Snowflake
+2Hi @samhayashi
My strength is in (oauth) web connections, not jdbc, but it looks like you could try the things in this snowflake doc (search for oauth on that page and it should bring up the right section). There's also a few stack overflow posts that might help if you get stuck.
If you want to connect using the HTTPCaller then you could set up a web connection in FME using those details from Azure and configure it (you could use sharepoint as an example/guide)
The Snowflake Reader/Writer in FME uses JDBC, so creating the web connection wouldn't be useful unless you're using the HTTPCaller.
+20- Safer
Hi there! I understand this thread is a bit dated, but I figured sharing the resource might help other users running into a similar issue. We now have the steps to configure OAuth for Snowflake using Azure AD as the auth provider. The steps are outlined here in our article: How to Authenticate with Snowflake: External OAuth with Azure AD
It walks through the setup for authorization code grant (with browser login) and client credentials (server-to-server flow) in Form and Flow
Our Getting Started article is also a great resource for other authentication options and working with Snowflake in FME: Getting Started with Snowflake
Hope this helps! 🙂
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.