Unable to make Snowflake OAUTH working via DCM
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Database Connection
- Gallery
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
