Configuring Snowflake application
    • PDF

    Configuring Snowflake application

    • PDF

    Article Summary

    Custom Role 

    Britive needs a custom role to connect to Snowflake and collect/grant roles to users. 

    Follow the steps to create a custom role:

    1. Login to Snowflake Console with ACCOUNTADMIN or SECURITYADMIN privilege.
    2. Run the following queries to create a custom role and assign the required privileges.  For more information, see Creating a Custom Role.
      1. create role BRITIVEROLE 
      2. grant manage grants on account to role BRITIVEROLE
    3. For managing Snowflake accounts using organization, assign ORGADMIN to the custom role using the query: grant role ORGADMIN to role BRITIVEROLE. 
    Note:
    Make sure to run this query from an account that has the ORGADMIN role enabled.

    User Account 

    Britive needs a user account with this custom role to connect to Snowflake REST endpoints for executing the queries.

    Follow the steps to create a user account: 

    1. Create a new user in Snowflake. For more information, see Creating Users.
    2. Create a private and public key pair and assign the same to the user. For more information, see Configuring Key Pair Authentication
    Note
    Create the private key without a password since Britive encrypts and stores all the keys.

    3. Assign the custom role created above to the user using the query: grant role <custom role> to user <BRITIVEUSER>.


    Was this article helpful?