Skip to main content

Troubleshooting Snowflake connectivity

Resolve common Snowflake connectivity issues when integrating Snowflake with Atlan.

Missing warehouse grants​

Error

The user doesn’t have USAGE and OPERATE grants on a warehouse.

Solution​

  1. Grant warehouse access to the role:

    GRANT OPERATE, USAGE ON WAREHOUSE "<warehouse>" TO ROLE atlan_user_role;

  2. Then, confirm that you grant the role to the new user:

    GRANT ROLE atlan_user_role TO USER atlan_user;

Missing authorized access to SNOWFLAKE.ACCOUNT_USAGE schema​

Error

The user doesn’t have authorized access to the SNOWFLAKE.ACCOUNT_USAGE database

Solution​

  1. Reach out to your account admin to grant imported privileges on the Snowflake database to the role:

    USE ROLE ACCOUNTADMIN;
    GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE atlan_user_role;

  2. If using a copied database, you'll need to grant the following permissions:

    GRANT USAGE ON DATABASE "<copied-database>" TO ROLE atlan_user_role;
    GRANT USAGE ON SCHEMA "<copied-schema>" IN DATABASE "<copied-database>" TO ROLE atlan_user_role;
    GRANT REFERENCES ON ALL VIEWS IN DATABASE "<copied-database>" TO ROLE atlan_user_role;

Missing usage grants on databases or schemas​

Error

The user doesn't have usage grants to the databases $missingDatabases and schemas $missingSchemas.

Solution​

  1. Grant missing permissions listed here for information schema extraction method.

Atlan IP not allowlisted​

Error

Atlan's current location or network isn't recognized by Snowflake's security settings. This can happen if Atlan's IP address isn't on the list of allowed addresses in Snowflake's network policies.

Solution​

  1. If you are using the IP allowlist in your Snowflake instance, you must add the Atlan IP to the allowlist. Contact Atlan support to obtain Atlan's IP addresses.

Incorrect credentials​

Error

The username or the password provided to connect to the Snowflake account is incorrect.

Solution​

  1. Sign into the Snowflake account for the specified host and verify that the username and password are correct.
  2. You can also create a new user, if required, by following the steps here.

Missing or unauthorized role​

Error

The role specified in your connection configuration doesn't exist in Snowflake or your user account doesn't have grant to use this role.

Solution​

  1. If the role doesn't exist or is missing the required grants, create a role and then grant the role to the user.

User account locked​

Error

The user account you're using to connect to Snowflake has been locked temporarily because of multiple incorrect login attempts.

Solution​

  1. Wait for the user account to unlock or create a different user account to continue.

Missing or unauthorized warehouse​

Error

The warehouse specified in your connection configuration doesn't exist in Snowflake or your user account doesn't have grant to use this warehouse.

Solution​

  1. Confirm that the warehouse name is configured correctly.
  2. Update the warehouse name in the configuration if your account is using a different warehouse. Create a role and then grant the role to the user for the updated warehouse.

Missing access to non-system databases or schemas​

Error

The configured user doesn't have usage grants to any database or schema. or The configured user doesn't have usage grants to any non-system database or schema.

Solution​

  1. This pertains to the information schema method of fetching metadata. Confirm that the user has authorized access to the databases and schemas to be crawled.
  2. Grant the requisite permissions as outlined here.