KNOWLEDGE BASE

Connecting to Snowflake Using Federated SAML IdP


Published: 07 May 2020
Last Modified Date: 19 May 2020

Question

How to connect to to Snowflake using your federated SAML identity provider and secure SSO (single sign-on)

Environment

  • Tableau Desktop 2019.1 or newer
  • Snowflake

Answer

Select 'Sign in using OAuth' as the Authentication method in the Snowflake connector in Tableau Desktop. 

If you are unable to connect to Snowflake using OAuth in Tableau Desktop, please verify the following: 
  1. The latest Snowflake ODBC driver is installed on your computer. You can download the driver from https://sfc-repo.snowflakecomputing.com/odbc/index.html
  2. Snowflake account administrators have configured OAuth access to Snowflake for Tableau as a partner application. See this Snowflake document.

Additional Information

For more information on how to connect to Snowflake using OAuth, see this Help document.

According to Snowflake documentation, Snowflake supports OAuth with Federated Authentication and SSO (single sign-on) using any identity provider (IdP) supported by Snowflake, which includes most SAML 2.0-compliant vendors as an IdP, such as:
  • Microsoft ADFS (Active Directory Federation Services)
  • Google G Suite
  • Microsoft Azure Active Directory
  • Onelogin
  • Ping Identity PingOne
Did this article resolve the issue?