Connect to Snowflake
Updated over a week ago

To connect Finout to your Snowflake account and see Snowflake costs in Finout, follow these simple steps:

  1. Log into your Snowflake console.

  2. Open a worksheet and paste this query inside.

use role accountadmin;
CREATE WAREHOUSE if not exists finout_warehouse WITH WAREHOUSE_SIZE = 'XSMALL' AUTO_SUSPEND=30 INITIALLY_SUSPENDED=TRUE;
create role finout_role;
create user finout_user password = '<YOUR_PASSWORD_HERE>' default_role = finout_role;
grant USAGE ON WAREHOUSE finout_warehouse to role finout_role;
grant role finout_role to user finout_user;
grant imported privileges on database snowflake to role finout_role;
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');
alter user finout_user SET NETWORK_POLICY = FINOUT_NETWORK_POLICY;

3. Choose a password, and replace the part that states <YOUR_PASSWORD_HERE>.

4. Fill in the information in Finout's console

Still need help? Please feel free to reach out to our team at [email protected].

Did this answer your question?