Administration user

In order to access all queries, all query plans and all locks on Snowflake account, SnowKill requires user with ACCOUNTADMIN role. Unfortunately, it is a fundamental limitation of Snowflake at this moment.

This is how to create such user for tests on trial account:

CREATE USER ADMIN_MONITOR
PASSWORD = '<password>'
DEFAULT_ROLE = 'ACCOUNTADMIN';

GRANT ROLE ACCOUNTADMIN TO USER ADMIN_MONITOR;

It is highly recommended to use key-pair authentication for production accounts instead of password:

CREATE USER ADMIN_MONITOR
RSA_PUBLIC_KEY = '<public_key>'
DEFAULT_ROLE = 'ACCOUNTADMIN';

GRANT ROLE ACCOUNTADMIN TO USER ADMIN_MONITOR;

Base functionality of SnowKill does not require warehouse to operate. There is no need to configure a warehouse for this user, unless you plan to use Snowflake table for storage.