Skip to main content
Dashboard Image

​
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

  • A. Password-Based Authentication
  • B. Public-Private Key Authentication
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)