Dev4Snow

Go back to ContentsGo back to previous page

Troubleshooting

Problem

Cause

Solution

When using SSO authentication multiple browser authentication tabs/windows are opened during Dev4Snow operation.

The Snowflake ODBC driver is not allowed to save the connection token. More information can be found in this link:

https://docs.snowflake.com/en/sql-reference/parameters.html#allow-id-token

 

 

The Snowflake account needs to be modified to allow saving SSO tokens. That can be done by running the following statement –it requires elevated permissions so ask an Admin to do it:

alter account set allow_id_token = true;

If you don’t have permissions to run it you may still have permissions to list the current value for the setting. Run the following statement to check the current value:

show parameters in account;

And look for key “ALLOW_ID_TOKEN” at the beginning of the list. The 2nd column should be “TRUE”, otherwise the connection token cannot be saved.

When using Multi-Factor Authentication multiple browser tabs/windows are opened during Dev4Snow operation.

The Snowflake ODBC driver is not allowed to save the MFA token. More information can be found in this link:

https://docs.snowflake.com/en/sql-reference/parameters.html#allow-client-mfa-caching

The Snowflake account needs to be modified to allow saving MFA tokens. That can be done by running the following statement –it requires elevated permissions so ask an Admin to do it:

alter account set allow_client_mfa_caching = true;

If you don’t have permissions to run it you may still have permissions to list the current value for the setting. Run the following statement to check the current value:

show parameters in account;

And look for key “ALLOW_CLIENT_MFA_CACHING” at the beginning of the list. The 2nd column should be “TRUE”, otherwise the MFA token cannot be saved.

An error is preventing Dev4Snow correct execution.

Possible configuration file error.

From the Dev4Snow Menu try restoring the application to default values.

If you are not able to access the Menu do it manually by opening the Dev4Snow AppData folder, usually located here:

C:\Users\<YOUR_USER>\AppData\Roaming\Dev4Snow

To restore everything to default values just delete all the files and folders in that location.