Error connecting Snowflake ODBC driver to Alteryx

Question

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-errors.

Has anyone else found a solution to this issue?

Thank you.

Luis

quipmaster · Answer

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.

apathetichell · Answer

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 · Answer

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