Installation

--  create role FH_APP_CONSUMER
CREATE ROLE FH_APP_CONSUMER COMMENT = 'Consumer role for FlowHigh Native App on SF';

-- grant required role permission to install application
GRANT CREATE APPLICATION ON ACCOUNT TO ROLE FH_APP_CONSUMER;
GRANT CREATE DATABASE ON ACCOUNT TO ROLE FH_APP_CONSUMER;
GRANT IMPORT SHARE ON ACCOUNT TO ROLE FH_APP_CONSUMER;

-- create X-Small virtual warehouse FH_WVH
CREATE OR REPLACE WAREHOUSE FH_VWH WITH WAREHOUSE_SIZE='X-SMALL' AUTO_SUSPEND=10;

-- grant FH_VWH modify/usage permissions to role FH_APP_CONSUMER
GRANT MODIFY, USAGE
  ON WAREHOUSE FH_VWH
  TO ROLE FH_APP_CONSUMER;   

  -- Create a new user and set email for the user. A user with email is required. 

  CREATE USER john_doe
    PASSWORD = '<specify password>'
    MUST_CHANGE_PASSWORD = FALSE;

 ALTER USER john_doe SET EMAIL='[email protected]';

    ALTER USER john_doe SET 
     DISPLAY_NAME = 'KB'
    FIRST_NAME = 'john'
    MIDDLE_NAME = 'b'
    LAST_NAME = 'doe';


-- to be able to accept Snowflake consumers terms and conditions
GRANT ROLE ORGADMIN TO ROLE FH_APP_CONSUMER;

-- to be able to access snowflake database from application consumer role
GRANT IMPORTED PRIVILEGES ON DATABASE snowflake TO ROLE FH_APP_CONSUMER; 

-- finally we grant the freshly created role to new user
GRANT ROLE FH_APP_CONSUMER
   TO USER john_doe;