Reduce Snowflake cost

Hunters continuously strives to improve and optimize the credit consumption of our
BYODL (Bring Your Own Data Lake) customer base. As part of this theme, Hunters has onboarded a solution that allows a greater level of visibility and analytics into its usage of Snowflake credits in applicable customer environments (Partner Connect).

This solution will give Hunters better control over compute resources which directly results in reduced Snowflake credit spend for our customers. For this purpose, you'll need to provide Hunters with the required permissions to your Snowflake instance.

📘 Note

You'll need an account admin role to perform these changes.

To allow Snowflake cost control:

1. Switch to an ACCOUNTADMIN role:

   Use role ACCOUNTADMIN;
   

2. Create a new dedicated warehouse:

   CREATE WAREHOUSE finout_warehouse WITH WAREHOUSE_SIZE = 'XSMALL' AUTO_SUSPEND=60  
   INITIALLY_SUSPENDED=TRUE;
   

3. Created a dedicated role:

   CREATE ROLE finout_role;
   

4. Create a new user and assign a default role and usage on the new warehouse:

   CREATE USER finout_user PASSWORD = '<Insert-new-password>' default_role =
   finout_role; GRANT USAGE ON WAREHOUSE finout_warehouse TO ROLE finout_role; 

   ⚠️ Attention

   Replace the <Insert-new-password> string with the password you want to assign to this user.

5. Assign the new role to the user:

   GRANT ROLE finout_role TO USER finout_user;
   

6. Grant imported privileges on the Snowflake database inside the account:

   GRANT IMPORTED PRIVILEGES ON DATABASE snowflake TO ROLE finout_role;
   

7. Whitelist the IP addresses which will access the data:

   CREATE OR REPLACE NETWORK POLICY FINOUT_NETWORK_POLICY ALLOWED_IP_LIST =  
   ('34.196.241.137', '212.59.64.84', '54.163.113.82', '44.196.75.137');
   

8. Assign the network policy to the user:

   ALTER USER finout_user SET NETWORK_POLICY = FINOUT_NETWORK_POLICY;
   

9. After performing the above configuration, share the password of the newly created user with Hunters, as well as your Snowflake credit cost.