Potential Causes

• The Snowflake account is disabled.

• The Snowflake user account is temporarily locked due to multiple failed login attempts.

• The Snowflake account administrator has locked the user account.

• Hevo’s IP addresses are not allowlisted.

Suggested Action(s)

• Verify that the Snowflake account is active, and billing is enabled.

• Wait for the temporary lockout period to end, then log in to your Snowflake account and test the connection again. Read Your user account has been temporarily locked due to too many failed attempts for more information on unlocking your Snowflake user account.

• Contact the Snowflake account administrator to unlock your user account.

• Verify that Hevo’s IP addresses for your region are allowlisted in Snowflake. To do this, perform the following steps:

  1. Log in to your Snowflake account as a user with the SECURITYADMIN role or a higher role.

  2. In the left navigation pane, hover the mouse over Governance & security and click Network policies.

     

  3. On the Network policies page, click + Network Policy.

  4. In the Create Network Policy window, you can do one of the following:

     • If you have already created a rule for Hevo’s IP addresses, click the Select Rule drop-down and select the existing rule.

       

     • To add a new rule for Hevo’s IP addresses, click New rule and do the following:

       

       1. In the Network rule name field, specify a unique name for the rule.

       2. Select the database from the drop-down in which you want to create the rule.

       3. In the Identifiers field, enter Hevo’s IP address for your region and press Enter to add the rule. Repeat this step to allowlist all the IP addresses.

       4. Click Create Network Rule.

  5. In the Network policy name field, specify a unique policy name of your choice. Read Identifier Requirements to know the constraints for a policy name in Snowflake.

  6. Click Create Network Policy.

     You can now view the new policy on the Network policies page.

  7. Click the More icon corresponding to your policy and select Activate On Account.

     

  The Hevo IP addresses are successfully allowlisted.