Unable to make Snowflake OAUTH working via DCM

Question

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:

DCM setup:

ODBC

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

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

JanLaznicka · Answer

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)

FilipeCosta · Answer

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:

Cheers,

Filipe