Documentation

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:

General Solution

Verify Account and Connection Details:‍

• Ensure that the account name, such as 'bca33396777666.us-east-1', 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:

Solution

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.

‍