version: 2

models:
  - name: msp_subclient_billable_cost_detail
    description: >
      Detailed billable cost records for MSP/CPPO sub-client tenants.
      These are tenants whose billing would otherwise be grouped into their MSP parent tenant.
      Contains transaction-level data with tenant and unit details.
    
  - name: msp_subclient_monthly_billing_distribution
    description: >
      Monthly billing distribution for MSP sub-clients with credit info and cluster details.
      Intermediate aggregation layer before final grouping.
    
  - name: msp_subclient_monthly_billing_group
    description: >
      Final grouped output for MSP sub-client billing analysis.
      Similar in structure to dws_cloud_tenant_monthly_billing_cost_distribution_group,
      but only contains tenants that would have been grouped under MSP/CPPO parents.
      Use msp_parent_tenant_id to link back to the parent tenant.