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/
        data_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/
        data_tests:
          - not_transient
          - has_data
          - clustered:
              arguments:
                by: roy_pay_payment_date