Run the following SQL, replacing <SECURE PASSWORD PROVIDED DURING INSTALLATION>:
Copy
Ask AI
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 viewscreate 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;
Run the following SQL, replacing <SECURE PASSWORD PROVIDED DURING INSTALLATION>:
Copy
Ask AI
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 viewscreate 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;
Request the public key from Pelanor Support
Run the SQL, replacing <PUBLIC KEY PROVIDED BY PELANOR>:
Copy
Ask AI
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 rsa_public_key='<PUBLIC KEY PROVIDED BY PELANOR>';-- same view definitions and grants as in Password-based method