OAuth 2.0 Support added for the Snowflake Input Connector : Chris Ames

OAuth 2.0 Support added for the Snowflake Input Connector
by: Chris Ames
blow post content copied from  salesforceblogger.com
click here to view original post

Our team has had a ton of requests for adding more authentication modes to our connector stack and specifically for Snowflake. OAuth is a standard in the industry and we have chosen to adopt it for adding the next level of auth functionality. Let’s have a closer look at this addition to the Snowflake connector.

OAuth based Connector/Connection at a Glance

Some might see OAuth as a simple thing they consume when they login to a web app like Salesforce, but several integration points need to come together to make this seem so simple. I’ll illustrate below and via the accompanying video how these moving pieces come together.

We need to create a link between Okta, an identity platform, and Snowflake and then from Okta to Salesforce and then from Salesforce to CRM Analytics.

Please keep in mind that from a Salesforce side and a Snowflake side these components are fairly well defined and have documented requirements. On the other hand in the Okta and other potential authentication services providers, there is a bunch of variables in how things are configured. What we have identified here is a scenario based on core functionality, if your Okta Admin has things configured in special ways we (Salesforce) may not have the means to facilitate every configuration and variation of the available use cases. If you come across an issue, raise it up and we will discuss it with you; just keep in mind we aren’t the Okta experts.

Ok, the simple steps

1: Create the Authorization Server in Okta; connecting your Snowflake and Okta accounts.

2: Create the Okta Application to facilitate the connection between Okta and Salesforce.

3: Create the Snowflake Security Integration to integrate with Okta.

4: Create a Salesforce Auth. Provider to connect to the Okata Application and provide the callback URL.

5: Create a Salesforce Named Credential to leverage the Auth. Provider’s Okta integration and set Scope for the integration into Snowflake.


6: Place the Named Credential Name in the connection dialog in Salesforce Data Pipelines/CRM Analytics.

And that’s it. You are now ready to extract data and transform it using data prep.

June 21, 2022 at 10:21PM
Click here for more details...

The original post is available in salesforceblogger.com by Chris Ames
this post has been published as it is through automation. Automation script brings all the top bloggers post under a single umbrella.
The purpose of this blog, Follow the top Salesforce bloggers and collect all blogs in a single place through automation.