version: 2
sources:
  - name: awal_fpa
    database: awal_sax
    schema: fpa
    tables:
# please retain alphabetical order for source table names

      - name: current_exchange_rates
        description: AWAL report "current_exchange_rates" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/current_exchange_rates/
        data_tests:
          - not_transient
          - has_data:
              arguments:
                amount: '>= 209'
      - name: fpa_pr_awal
        description: AWAL report "fpa_pr_awal" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fpa_pr_awal/
        data_tests:
          - not_transient
          - has_data

      - name: fpa_recoupment
        description: AWAL report "fpa_recoupment" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fpa_recoupment/
        data_tests:
          - not_transient
          - has_data:
              arguments:
                amount: '>= 1951647'
      - name: fund_lookup
        description: AWAL report "fund_lookup" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fund_lookup/
        data_tests:
          - not_transient
          - has_data

      - name: fund_lookup_view
        description: AWAL report "fund_lookup_view" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fund_lookup_view/
        data_tests:
          - not_transient
          - has_data

      - name: historical_recoupment
        description: AWAL report "historical_recoupment" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/historical_recoupment/
        data_tests:
          - not_transient
          - has_data

      - name: processed_revenue
        description: AWAL report "processed_revenue" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/processed_revenue/
        data_tests:
          - not_transient
          - has_data
          - clustered:
              arguments:
                by: business_unit,payment_year
      - name: sax_recoupment
        description: AWAL report "sax_recoupment" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/sax_recoupment/
        data_tests:
          - not_transient
          - has_data

      - name: segmentation_lookup
        description: AWAL report "segmentation_lookup" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/segmentation_lookup/
        data_tests:
          - not_transient
          - has_data

      - name: sub_deal_agreement_mappings
        description: AWAL report "sub_deal_agreement_mappings" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/final/sub_deal_agreement_mappings/
        data_tests:
          - not_transient
          - has_data

      - name: territory_groups
        description: AWAL report "territory_groups" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/territory_groups/
        data_tests:
          - not_transient
          - has_data