Snowflake

set ryft_username='RYFT';
set ryft_warehouse_size='XSMALL';
set ryft_warehouse_name='RYFT_WH';
set ryft_role_name='RYFT_ROLE';

USE ROLE ACCOUNTADMIN;

CREATE WAREHOUSE IF NOT EXISTS identifier($ryft_warehouse_name) WAREHOUSE_SIZE=$ryft_warehouse_size INITIALLY_SUSPENDED=TRUE
    AUTO_SUSPEND = 1 AUTO_RESUME = TRUE;

-- Create Ryft role
CREATE ROLE IF NOT EXISTS identifier($ryft_role_name);

-- Create Ryft user
CREATE USER IF NOT EXISTS identifier($ryft_username) DEFAULT_ROLE=$ryft_role_name TYPE=SERVICE;
GRANT ROLE identifier($ryft_role_name) TO USER identifier($ryft_username);

-- Grant permissions to the WH
GRANT USAGE ON WAREHOUSE identifier($ryft_warehouse_name) TO ROLE identifier($ryft_role_name);

-- Grant privileges to allow access to query history and metadata
GRANT IMPORTED PRIVILEGES ON DATABASE "SNOWFLAKE" TO ROLE identifier($ryft_role_name);
GRANT MONITOR ON ACCOUNT TO ROLE identifier($ryft_role_name);

-- Grant privileges to to audit the current access state
GRANT DATABASE ROLE SNOWFLAKE.SECURITY_VIEWER TO ROLE identifier($ryft_role_name);

ALTER USER identifier($ryft_username) SET RSA_PUBLIC_KEY='<pub key>';

18.211.150.201
52.45.62.176
35.174.30.119