Share
Explore
KPIs with Snowflake
Display key metrics powered by your data in Snowflake.
Sync in key performance indicators (KPIs) from Snowflake to create customizable and interactive dashboards of your data. Add or edit the queries in the table, then select the metric for each callout box and adjust the icons as desired.
15,163
15,163
Active Users
11,840
11,840
Enterprise Seats
$870,315
870,315
Revenue
Source data
Refresh data
Snowflake queries
Name
Query
Value
1
Active Users
SELECT
ROUND(SUM(c.paid_seats) * 0.555) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
15,163
2
Enterprise Seats
SELECT
SUM(c.paid_seats) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
JOIN SAMPLE_DATA.ACCOUNT_PLAN.PLANS p USING (plan_id)
WHERE
p.name = 'Enterprise'
11,840
3
Revenue
SELECT
SUM(c.paid_seats * p.price_per_seat_usd) AS value
FROM
SAMPLE_DATA.ACCOUNT_PLAN.CUSTOMERS c
JOIN SAMPLE_DATA.ACCOUNT_PLAN.PLANS p USING (plan_id)
870,315
No results from filter
Snowflake query results
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.