1. Create a Pelanor Warehouse

1

Log in to Snowsight

Log in as an ACCOUNTADMIN.

2

Access Warehouses

Navigate to Admin → Warehouses.

3

Create a new warehouse

Click + Warehouse in the top right.

  • Name: PELANOR
  • Size: X-Small
  • Auto Suspend: set to lowest available value

2. Set up Pelanor Integration

1

Access Dashboards

Navigate to Projects → Dashboards.

2

Create a dashboard

Click + Dashboard

  • Dashboard Name: e.g., “Pelanor Integration”
3

Select warehouse

  1. Click No Warehouse Selected
  2. Select PELANOR warehouse from the list
4

Create tile from SQL

Click New Tile → From SQL Worksheet


Choose Your Authentication Mode

Run the following SQL, replacing <SECURE PASSWORD PROVIDED DURING INSTALLATION>:

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;

3. Validation

Run the following to test setup:

use role pelanor;
select * from pelanor.public.query_history limit 1;

You should see at least one row. If not, recheck your configuration.


4. Retrieve Snowflake IDs

Account ID

  • GUI: Profile → About / Account
  • SQL:
    select current_account();
    

Organization ID

  • Run:
    select distinct ORGANIZATION_NAME
    from SNOWFLAKE.ORGANIZATION_USAGE.WAREHOUSE_METERING_HISTORY;
    

Do not confuse the “account locator” with the Account ID.


5. Send to Pelanor

Provide the following to your Pelanor contact:

  • Snowflake Organization ID
  • Snowflake Account ID
  • Database Parameters (if changed):
    • warehouse (default: PELANOR)
    • database (default: pelanor)
    • schema (default: PUBLIC)
    • user (default: pelanor)
    • role (default: pelanor)