version: 2

sources:
  - name: facts
    database: facts
    schema: "{{ target.schema if target.name == 'prod' else 'QA' }}"
    tables:
      - name: dim_artist
      - name: dim_country
      - name: dim_imprint
      - name: dim_release
      - name: dim_store
      - name: dim_track_clean_mv
      - name: dim_transactiontype
      - name: dim_period
      - name: dim_currency
      - name: currency_exchange_rates
      - name: fact_sales
      - name: dim_track
      - name: performance_nr_sound_recording
      - name: vw_workstation_summary
      - name: dim_brand
      - name: dim_label
      - name: dim_project
      - name: dim_isrc

  - name: royalty_accounting
    database: royalty_accounting
    schema: "{{ target.schema if target.name == 'prod' else 'QA' }}"
    tables:
      - name: vw_abacus_fact_sales_distro_v3
      - name: vw_abacus_fact_sales_nr_v3
      - name: vw_abacus_fact_sales_publishing
      - name: stmt_db_sales_distro
      - name: abacus_fact_sales_unified_dbt
      - name: revenue_distro_dbt
      - name: account_statement_periods_dbt
      - name: workstation_summary_dbt

  - name: royalty_accounting_reporting
    database: royalty_accounting_reporting
    schema: "{{ target.schema if target.name == 'prod' else 'QA' }}"
    tables:
      - name: vw_oa_contract

  - name: oar_art_relations
    database: orchard_app_reporting_v2
    schema: art_relations_prod_art_relations
    tables:
      - name: artist_info
      - name: booked_vendor_contract_snapshot
      - name: currencies
      - name: currency_exchange_rates
      - name: customer_master_master
      - name: distribution_format
      - name: manual_adjustment
      - name: manual_adjustment_category
      - name: project
      - name: release_manual_adjustment
      - name: releases
      - name: track
      - name: vendor
      - name: vendor_contract
      - name: subaccount

  - name: oar_royalty_accounting
    database: orchard_app_reporting_v2
    schema: "{{ 'prod_royalty_accounting_royalty_accounting'
      if target.name == 'prod'
      else 'qa_royalty_accounting_royalty_accounting'
    }}"
    tables:
      - name: account_contract
      - name: account_payment_term
      - name: contract
      - name: ledger_adjustment_detail_applied
      - name: ledger_adjustment_applied
      - name: reference_adjustment_type
      - name: worksheet_adjustment
      - name: worksheet_adjustment_detail
      - name: statement_period
      - name: statement_period_payment_entity
      - name: reference_transaction_type
      - name: reference_transaction_type_group_transaction_type
      - name: reference_transaction_type_group
      - name: exchange_rate
      - name: accounting_period
      - name: accounting_run
      - name: abacus_event
      - name: abacus_state
      - name: contract_advance
      - name: ledger_account_contract
      - name: ledger_accounting_run_balance
      - name: ledger_contract_advance_applied
      - name: ledger_correction
      - name: payment_group_payment
      - name: payment_group_payment_account

  - name: test_fixtures
    schema: "{{ target.schema }}"
    tables:
      - name: expected_abacus_fact_sales_unified
      - name: expected_account_statement_periods
      - name: expected_combined_adjustments
      - name: expected_combined_adjustments_by_type
      - name: expected_combined_advances
      - name: expected_combined_expenses
      - name: expected_combined_expenses_by_artist
      - name: expected_combined_expenses_by_imprint
      - name: expected_combined_payments
      - name: expected_contract
      - name: expected_expenses_by_imprint
      - name: expected_expenses_by_subaccount
      - name: expected_ledger_summary
      - name: expected_payments
      - name: expected_revenue_by_activity_month
      - name: expected_revenue_by_artist
      - name: expected_revenue_by_country
      - name: expected_revenue_by_imprint
      - name: expected_revenue_by_product_distro
      - name: expected_revenue_by_project
      - name: expected_revenue_by_recording_distro
      - name: expected_revenue_by_recording_nr
      - name: expected_revenue_by_statement_period
      - name: expected_revenue_by_store
      - name: expected_revenue_by_subaccount
      - name: expected_revenue_by_track
      - name: expected_revenue_by_transaction_type
      - name: expected_revenue_distro
      - name: expected_revenue_publishing
      - name: expected_revenue_nr
      - name: expected_workstation_fact_sales_unified
      - name: expected_workstation_summary