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

  - name: royalty_detail
    description: AWAL report "royalty_detail" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/rdl_datasets/final/royalty_detail/
    tests:
    - not_transient
    - has_data

  - name: royalty_payment_detail
    description: AWAL report "royalty_payment_detail" from s3://prod-orcd-awal-drop/AWAL_TO_ORCH/rdl_datasets/final/royalty_payment_detail/
    tests:
    - not_transient
    - has_data
    - clustered:
        by: roy_pay_payment_date