version: 2

sources:
  - name: billing
    database: gcp-digital-bi
    schema: billing
    tables:
      - name: aws_prod_billing_2022
      - name: gcp_prod_billing_2022
      - name: o11y_usage_proportion
      - name: aws_nonprod_billing_daily_detail_view
models:
  - name: stg_aws_prod_billing_2022_managed_compat
    description: >
      Legacy-compatible AWS prod billing table built from the managed
      digital-bi-dbt cloud billing staging source. It preserves the old
      aws_prod_billing_2022 shape for the three prod accounts, uses nested
      product.key_value['region'] for product_region, and excludes managed-only
      discount and credit line item types to match legacy cost semantics.