Error connecting Snowflake ODBC driver to Alteryx

[quipmaster]

Hello Maveryx,

When connecting the Snowflake ODBC driver to Alteryx, some of my teammates have received the following error.

[Snowflake][Snowflake] (4) REST request for URL *** failed: HTTP error (http error) - code=404 Verify that the hostnames and portnumbers in SYSTEM$ALLOWLIST are added to your firewall's allowed list. To further troubleshoot reference the following article : https://docs.snowflake.com/en/user-guide/client-connectivity-troubleshooting/error-messages#odbc-err....

Has anyone else found a solution to this issue?

Thank you.

Luis

[DavidSkaife]

Hi @quipmaster 

When you say some of your teammates I'm going to assume that some can connect?

Get those that cannot connect to check that the URL on the ODBC is set to "<MYACCOUNT>.snowflakecomputing.com" and not anything else like "<MYACCOUNT>.snowflakecomputing.com/console/login"

If i change the ODBC to the one with /console/login I also get the same error message

[quipmaster]

Hi David,

Yes, myself and a handful of others on the team can connect. 

We all use this URL.

1. User: your aisd email address
2. Password: your aisd password
3. Server: "<y035410.us-east-2.aws>.snowflakecomputing.com"

*minus the " and <>.

Yet two teammates get error messages.

Thank you for your guidance.

Luis

[apathetichell]

you are authenticated via username/password - not externalbrowser/sso? this is bad. do not do this.

having said that - can you confirm that there are no restrictions on the snowflake side for what ips users can authenticate from? my hunch is this is on the snowflake side or otherwise specific to your system either outbound or inbound (to snowflake)... my recommendations would be:

1) switch to sso.

2) figure out if those who can connect are on a vpn.

3) get on that vpn (if applicable)

4) reach out to the snowflake team re: ip whitelistings.

and as a final reminder - get your ODBC connections to work in ODBC 64 FIRST. Use Test. - then troubleshoot if the Alteryx connection is working.

[quipmaster]

Hello apathetichell,

Thank you for your guidance. I am working with our database architects to use OAuth but we are not there yet. 

I will confirm that users are on connected on VPN. 

Let me test the ODBC 64 first. The test in Alteryx have notified me that the connection failed. 

Luis

[apathetichell]

Hey Luis - totally - backing up a step - I'm trying to say troubleshoot what is a Snowflake/system issue and what is an Alteryx issue. There are lots of folks here who are knowledgeable on Alteryx - but Snowflake/systems issues are not things people here really excel at  - and there are probably other corners of the internet (Stack Overflow/Reddit/Snowflake Community) which can troubleshoot those issues.

Are you connecting via service account via Oauth? I am not a fan of Snowflake Oauth for Service Account connections. If your Snowflake team  want to reach out to me I can go into more detail why.

[quipmaster]

hi Apathetichell, 

turns out that it was user error. 

the url had a typo.

also, the warehouse name is case sensitive.

the reason I am pushing for OAuth is because, currently, for each instance of snowflake on alteryx requires duo authentication- multiple authentications.

I will send you a message.

this issue is resolved. user error on URL and warehouse.

thank you everyone.