Configuring Snowflake application

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. 

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. 

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