I have CDM prompt that runs a local tableau prep flow. The tableau prep flow connects to a snowflake database schema and then pushes the cleaned data to a new table/schema in the same snowflake database. My companies IT does not want me to embed my credentials and won’t provide me with my password, we only use SSO.

I have downloaded snowSQL with hopes to incorpoate the cmd SSO for snowflake.

snowsql -a <server info> -u <my email> --authenticator externalbrowser

I am able to run this line from the cmd and SSO works. When I attempt to incorporate it into the cmd prompt for running tableau prep flow it does not work.

Here is the cmd prompt provided by tableau to run a flow locally that connects and pushes to a database.

"[Tableau Prep Builder install location]Tableau Prep Builder <version>scripts"tableau-prep-cli.bat -c "pathto[your credential file name].json" -t "pathto[your flow file name].tfl"

When incorporating the snowflake SSO in the cmd promp I recieve the following errors. The flow runs with my local tableau flow GUI.

[Tableau Prep Builder install location]Tableau Prep Builder <version>scripts"tableau-prep-cli.bat "snowsql -a <server info> -u <my email> --authenticator externalbrowser" -t "pathto[your flow file name].tfl

Details:
There are errors in the flow. Unable to run the flow.
Check that the credentials .json file includes all required credentials.
Open the flow in Tableau Prep to view error details.

TableauException: ConnectionID value not known

Check that the connection is valid then try again.

Details:
There are errors in the flow. Unable to run the flow.
Check that the credentials .json file includes all required credentials.
Open the flow in Tableau Prep to view error details.
Check that the connection is valid then try again.

Where in the cmd prompt string would I incorporate the SSO command?