Snowflake

use role accountadmin;
create database pelanor;
create role pelanor;
create user pelanor;
grant role pelanor to user pelanor;
grant role pelanor to role accountadmin;
grant all on warehouse pelanor to role pelanor;
alter user pelanor set DEFAULT_WAREHOUSE=pelanor, DEFAULT_ROLE=pelanor;
alter user pelanor set password '<SECURE PASSWORD PROVIDED DURING INSTALLATION>';

-- Create views
create view PELANOR.PUBLIC.QUERY_HISTORY as (
  select * from SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY
);
create view PELANOR.PUBLIC.WAREHOUSE_METERING_HISTORY as (
  select * from SNOWFLAKE.ORGANIZATION_USAGE.WAREHOUSE_METERING_HISTORY
);
create view PELANOR.PUBLIC.USAGE_IN_CURRENCY_DAILY as (
  select * from SNOWFLAKE.ORGANIZATION_USAGE.USAGE_IN_CURRENCY_DAILY
);
create view PELANOR.PUBLIC.TABLE_STORAGE_METRICS as (
  select * from SNOWFLAKE.ACCOUNT_USAGE.TABLE_STORAGE_METRICS
);
create view PELANOR.PUBLIC.DATABASE_STORAGE_USAGE_HISTORY as (
  select * from SNOWFLAKE.ORGANIZATION_USAGE.DATABASE_STORAGE_USAGE_HISTORY
);
create view PELANOR.PUBLIC.PIPES as (
  select * from SNOWFLAKE.ORGANIZATION_USAGE.PIPES
);
create view PELANOR.PUBLIC.PIPE_USAGE_HISTORY as (
  select * from SNOWFLAKE.ORGANIZATION_USAGE.PIPE_USAGE_HISTORY
);
create view PELANOR.PUBLIC.SEARCH_OPTIMIZATION_HISTORY as (
  select * from SNOWFLAKE.ACCOUNT_USAGE.SEARCH_OPTIMIZATION_HISTORY
);

grant usage on schema pelanor.public to role pelanor;
grant usage on database pelanor to role pelanor;
grant select on all views in schema pelanor.public to role pelanor;