We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Unable to make Snowflake OAUTH working via DCM

JanLaznicka
9 - Comet

Hey everyone,

 

Has anyone managed to get a DCM data source for Snowflake working with OAUTH authentication? I tried multiple setups and discussed the security integration with Snowflake support, but I haven't managed to get it working. This is what I have:

 

Security integration:

JanLaznicka_0-1669156287023.png

 

DCM setup:

JanLaznicka_1-1669156359347.png

 

ODBC

JanLaznicka_2-1669156410727.png

 

This is the error when I try it out in Designer (on the Server node):

JanLaznicka_3-1669156631069.png

 

I can connect to Snowflake both via normal username and password and keypair authentication, so no network/firewall issues.

 

Thanks for your help and ideas.

 

Cheers,

Jan

2 REPLIES 2
FilipeCosta
5 - Atom

Hi,

I had a similar issue and had to change the port to 5000.

This is what i got from the Alteryx side at that time:

 

Snowflake integration:

create security integration Oauth

  type = oauth

  enabled = true

  oauth_client = custom

  oauth_client_type = 'confidential'

  oauth_redirect_uri = 'http://127.0.0.1:5000/oauth2/login/redirect'

  oauth_issue_refresh_tokens = true

  oauth_refresh_token_validity = 7776000

  OAUTH_ALLOW_NON_TLS_REDIRECT_URI = TRUE

 

Alteryx Configuration:

FilipeCosta_1-1669203782032.png

 

Cheers,

Filipe

JanLaznicka
9 - Comet

Thanks Filipe, I managed to make it working, for me it was a combination of 2 things:

1. Removing /oauth/authorize from the end of OAUTH authority URL

2. Adding / at the end of the OAUTH_REDIRECT_URI (though this one might not be needed)