Create Snowflake Datasource with Username & Password (2FA)

Question & Answer
,
5

Hey!

I’m also anticipating the mandatory MFA change from Snowflake and am implementing the OAuth connection method. Thought it might be helpful to share my progress and ask questions here.

I’m following the user guide for creating an OAuth connection.

Currently defining the SECURITY INTEGRATION in snowflake. Here’s my command so far:

create security integration
  AWS_QUICKSIGHT_OAUTH
  comment = 'Custom Security Integration for AWS Quicksight. '
  type = OAUTH
  oauth_client = CUSTOM
  oauth_client_type = 'CONFIDENTIAL' 
  oauth_redirect_uri = 'https://quicksight.aws.amazon.com/oauth2/callback' 
  oauth_refresh_token_validity = 7776000; 
  pre_authorized_roles_list = ( '<custom_quicksight_role>')
  enabled = 'TRUE'
  ;

select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('AWS_QUICKSIGHT_OAUTH');

Question:
do I have the correct oauth_redirect_uri? I’m currently going off of chatGPT’s recommendation. I asked it to show me the docs where that URI is listed and it said “trust me bro”, so.

1 Like