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/

  - 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/
  - name: fpa_recoupment
    description: AWAL report "fpa_recoupment" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fpa_recoupment/

  - name: fund_lookup
    description: AWAL report "fund_lookup" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/fund_lookup/

  - 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/


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

  - name: processed_revenue
    description: AWAL report "processed_revenue" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/processed_revenue/

  - name: sax_recoupment
    description: AWAL report "sax_recoupment" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/sax_recoupment/

  - name: segmentation_lookup
    description: AWAL report "segmentation_lookup" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/FINANCIAL_REPORTING/FPA/segmentation_lookup/
  - 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/

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