Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Parameters inDB ODBC Connection to Snowflake

DarinP
Alteryx Alumni (Retired)

Hello,

 

I'm attempting to parameterize the schema value in the ODBC connection string for an InDB connection to Snowflake and can't figure out how to pass a value in.

 

Snowflake users often switch roles depending upon their activity and creating a new ODBC connection for every role seems cumbersome.  The best way this can be accomplished is to parameterize the ODBC connection which contains schema and role.

 

The connection string is as follows:

odbc:DSN=SnowflakeODBC;UID=dpearce;PWD=__EncPwd1__;SCHEMA=myschema;ROLE=myrole

 

I can adjust the schema and role when I change these manually in the ODBC connection, but cannot pass in values without touching the ODBC connection.  I've tried both user connection and file connection.


Any suggestions would be helpful,

 

Darin

1 REPLY 1
GrahamL
8 - Asteroid

I haven't tested this but couldn't you use the Pre SQL Statement to USE ROLE <role_name> and then wrap the connection and input data tool in a macro?

 

I'll try and send an example when I've got a bit more time to spare

Labels