Account cmrr

1-- core.younium.account_cmrr
2-- Current committed MRR, ACV and TCV per customer account, as Younium computes
3-- them, with each account's share of total CMRR.
4-- Grain: one row per account, as of the last sync. Not history: for movements over
5-- time use core.younium.mrr_movements.
6--
7-- cmrr is in the account's own currency; cmrr_base and the share are in the
8-- Younium base currency, so they add up across accounts.
9
10SELECT
11    account_id,
12    account_number,
13    account_name,
14    account_type,
15    parent_account_id,
16    country,
17    is_inactive,
18    created_at,
19    currency,
20    cmrr,
21    base_currency,
22    cmrr_base,
23    cmrr_base * 12                                        AS carr_base,
24    acv_base,
25    tcv_base,
26    SAFE_DIVIDE(cmrr_base, SUM(cmrr_base) OVER ())        AS share_of_total_cmrr,
27    RANK() OVER (ORDER BY cmrr_base DESC)                 AS cmrr_rank
28FROM {{staging.younium.account}}