Snowflake - Troubleshooting

Updated on

Jan 29, 2024

While configuring your Snowflake connection, you may encounter several issues. Understanding these common errors can help streamline the setup process and facilitate quick resolutions.

Wrong input data

  • Wrong Account (non-existing)
  • Wrong region in Account
  • Wrong Account (existing)
  • Wrong Username
  • Wrong Password
  • Wrong role
  • Wrong Database Name
  • Wrong schema
  • Wrong Warehouse
  • Wrong permissions

Error messages:

{%docs-informer error%} "Failed to connect to DB: Verify the account name is correct: ``` 1```." "Failed to connect to DB: Incorrect username or password was specified." "Failed to connect to DB: Role 'INVALID' specified in the connect string does not exist or not authorized." "Your credentials are invalid! Please, check that your warehouse, database and schema are provided correctly." {%docs-informer-end%}

General Solution

Verify Account and Connection Details:

  • Ensure that the account name, such as '', is correctly entered and corresponds to an existing and accessible database account.
  • Double-check the hostname or IP address for any typographical errors and ensure it matches your database server's correct address.

Check Login Credentials:

  • Review the username and password you are using for accuracy. Make sure they are the ones associated with your database account.
  • If unsure, try resetting your password or contact your database administrator for assistance.

Role Validation:

  • Confirm that the role specified in your connection string, like 'PUBLIC' or any custom role, exists and that you have the authorization to use it.
  • If the role is 'INVALID' or unauthorized, consult your system administrator to assign a valid role or to grant necessary permissions.

Credentials Verification:

  • For errors stating "Your credentials are invalid," check that your warehouse, database, and schema names are provided correctly and match your database settings.
  • Ensure that the user is correctly assigned to the specified role and has all required privileges to access and operate within the database.

Refer to the Setup Guide Documentation

IP problems

  • Static IP is not selected

Error message:

{%docs-informer error%} "Failed to connect to DB. IP ```{{xx.xx.xx.xx}}``` is not allowed to access Snowflake." {%docs-informer-end%}


Whitelist IP Address:

  • Access your Snowflake account settings and navigate to the network policy section.
  • Add the IP address ```{{xx.xx.xx.xx}}``` to the whitelist to allow it access to Snowflake. Ensure that this IP address is safe and should have access to your database.

Configure Static IP Option:

  • In your database connection parameters, locate the option to "Use static IP."
  • Set this option to "YES" to ensure a stable and consistent connection through a specified IP address.

Verify Network Policy:

  • After updating your network policy, review it to confirm that the changes have been correctly applied and the IP address is now authorized.

Test Connection:

  • Retry connecting to the database to see if the issue is resolved.

{%docs-informer info%} If none of the provided solutions worked, feel free to raise a request via the Service Desk {%docs-informer-end%}

Schema information

Setup guide


No items found.


Troubleshooting guides

Check out troubleshooting guides for
Snowflake - Troubleshooting


Frequently asked questions

No items found.
☶ On this page
Related articles
No items found.
No items found.


Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.