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 requires a user account with the custom role created above to connect to Snowflake REST endpoints and execute queries.

Follow the steps to create a user account: 

1. Create a new user in Snowflake. For more information, see Creating Users.

2. Generate a public-private key pair and assign it to the user. Optionally, you can create a password-protected private key. For more details, 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>.