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 2^nd 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 2^nd column should be “TRUE”, otherwise the MFA token cannot be saved.

A Database or Schema is not showing up in the tree.

The missing Database or Schema is not selected in favorites.

Click the star icon () right above the tree to include the missing Database or Schema.

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.