Question

Use Azure based OAuth connection to connect to Snowflake

  • 10 March 2021
  • 1 reply
  • 0 views

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!


1 reply

Badge +2

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

Reply