OAuth Implementation with Tableau and SnowflakeCover Image

Author: Shashank Sanehi


Introduction

OAuth is an open-standard authorization protocol or framework that gives users the

ability for secure designated access. For example, we can tell Snowflake its okay to

use Tableau without giving the password credentials to Tableau.


Prerequisites

1) Install Tableau desktop or use Tableau online.

2) A Snowflake Account.


Steps to be followed

1) Run the following commands in Snowflake, this will create an integration with Tableau.


create role app_role;

grant role app_role to user <username>;

alter user <username> set DEFAULT_ROLE = 'app_role';


create security integration tableau_oauth

type = oauth

enabled = true

oauth_client = tableau_desktop


2) Connect via a server in Tableau Desktop and find Snowflake option in it.



3) Paste your account URL in the server and sign in using Oauth.



4) Enter your credentials.



5) Allow the permission.



6) Then your server will be connected to Snowflake and you can use the databases directly in Tableau using Oauth.


Conclusion

We have successfully connected tableau to snowflake using Oauth.


References

1) Tableau docs for connecting to Snowflake.


https://help.tableau.com/current/pro/desktop/en-

us/examples_snowflake.htm

17 views0 comments

Recent Posts

See All