Run command accessing environment variables

[cmcclellan]

I have Designer and Desktop Scheduler.

I have a Run command that looks like this

(real connection name redacted obviously).

The configuration file specifies the Snowflake login credentials (username and password) and has worked perfectly for years.

Today we are switching to key-pair authentication - pretty simple. I can generate the public and private keys, update the username in Snowflake with the public key, set the environment variable in Windows, etc....

a) When I run the workflow in Alteryx (just a normal Ctrl-R), when the Run command executes it prompts me for the private key passphrase ( so it doesn't "see" the environment variable )

b) When I try from the command line and run 

snowsql -c XXXXX -f bulk_load.sql

it works fine and doesn't prompt for the environment variable

c) When I schedule the workflow via Desktop Scheduler it also works fine and doesn't prompt for the environment variable

Why does a) not see/read the environment variable and the others do?

Has anyone else done this with Snowflake and key-pair authentication ?

 

[apathetichell]

@cmcclellan-> did you get anywhere on this? I think the easiest way to test is probably to open a command prompt as admin -> set your passphrase as a variable there. run your alteryx workflow.