Schema

1version: 2
2
3models:
4    - name: dim_customer
5      description: One row per paying customer.
6      columns:
7          - name: customer_id
8            data_tests: [unique, not_null]
9          - name: country
10
11    - name: fct_revenue_item
12      description: Deferred-revenue recognition at (line item, service month) grain, in base currency.
13      data_tests:
14          - dbt_utils.unique_combination_of_columns:
15                combination_of_columns: [revenue_item_id, month]
16      columns:
17          - name: revenue_item_id
18            data_tests: [not_null]
19          - name: customer_id
20            data_tests:
21                - not_null
22                - relationships:
23                      to: ref('dim_customer')
24                      field: customer_id
25          - name: amount
26            description: Revenue recognized in this month, in the reporting base currency.
27            data_tests: [not_null]
28
29    - name: fct_mrr
30      description: Monthly MRR/ARR with the new/expansion/contraction/churn bridge.
31      columns:
32          - name: month
33            data_tests: [unique, not_null]
34          - name: mrr
35            data_tests: [not_null]