In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Connecting Data From Snow Flake

maxwell123
6 - Meteoroid

Hello everybody,

 

I am currently using Alteryx and pulling data from Snowflake. However when I click load in data and click on ODBC under "Snowflake" to connect to my ODBC driver. it brings me to a "Connection Manager" window instead of a "ODBC Connection" window where it asks for my username, password and "Data Source Name" (Screenshots attached).

 

I have the snowflake ODBC driver downloaded and successfully connected from my laptops ODBC 64 bit menu to Snowflake with all the correct information filled out. My question is what am I doing wrong in the process that wont allow Alteryx to recognize my ODBC connection, therefore not allowing me to log in with the credentials I filled out for the SnowflakeDSIIDriver. 

What I need to appear to connect-

7b3d4825-1577-49a0-a1cd-295099029b42.jpg

What is appearing-

e63dc870-333d-4c6f-8dc4-550a06abdb5a.jpg

Proof of successful ODBC connection

 

6fd20cd5-c62b-4653-9ff8-5c8dbfd55669.jpg

6 REPLIES 6
alexnajm
18 - Pollux
18 - Pollux

Uncheck “Use Data Connection Manager” in your input data tool!

apathetichell
19 - Altair

I use manage connections in-db via advanced options and set up an In-DB connection.

maxwell123
6 - Meteoroid

For some reason it doesn't appear to be an option on the input data tool. Do you know how I could shut it off?

 

 

 

 

 

 

apathetichell
19 - Altair

@maxwell123 are you on 2024.1? try the In-DB route.

maxwell123
6 - Meteoroid

If on 2024.1 is there no longer a way to directly connect Snowflake to an input data tool? IE I have to use the in-DB tool to connect it? Is there any way to simply configure an option somewhere that would skip the "Data Connection Manager" window?

apathetichell
19 - Altair

sorry - I can't answer that.  I don't use 2024.1 (or 2023. or really 2022). I can tell you I use In-DB. I like In-DB. For DCM can you hit new? can you leave you tag for ODBC 64 connection. can you leave name/password blank?

Labels
Top Solution Authors