sources:
  - name: hidden_content
    database: prod
    tables:
      - name: itunes_hidden
        columns:
          - name: apple_id
          - name: upc
          - name: grid
          - name: vendor_id
          - name: artist_name_via_itunes
          - name: album_name_via_itunes
          - name: genre
          - name: total_tracks
          - name: total_discs
          - name: is_complete
          - name: content_owner
          - name: label_name
          - name: audio_must_be_redelivered_for_itunes_plus
          - name: reason
          - name: import_date
          - name: hide_date
          - name: ingest_date
          - name: days_until_hidden
          - name: original_reason
          - name: appleid_reason

      - name: itunes_hidden_view
        columns:
          - name: date_hidden
          - name: import_date
          - name: content_owner
          - name: apple_id
          - name: upc
          - name: grid
          - name: vendor_id
          - name: artist
          - name: album
          - name: genre
          - name: total_tracks
          - name: total_discs
          - name: is_complete
          - name: label_name
          - name: artistid
          - name: master_label
          - name: audio_must_be_redelivered_for_itunes_plus
          - name: reason
          - name: labelid
          - name: label_client_manager
          - name: ingest_date
          - name: mkt_priority
          - name: label_priority

      - name: itunes_ticket_notes
        columns:
          - name: upc
          - name: appleid
          - name: date
          - name: ingest_date
          - name: note
          - name: ticketid
          - name: unique_note_col

      - name: itunes_tickets
        columns:
          - name: upc
          - name: album_title
          - name: appleid
          - name: content_owner
          - name: ticketid
          - name: ticket_open_date
          - name: ticket_type
          - name: track_name
          - name: unique_tix_col

      - name: itunes_tickets_action_required_view
        columns:
          - name: date_note
          - name: ingest_date
          - name: date_added
          - name: upc
          - name: appleid
          - name: ticketid
          - name: ticket_type
          - name: track_name
          - name: album_title
          - name: album_artist
          - name: note
          - name: imprint
          - name: label_name
          - name: label_client_manager
          - name: labelid
          - name: is_priority

      - name: priority_appleids
        columns:
          - name: appleid
          - name: is_priority

      - name: spotify_hidden_view
        columns:
          - name: date_hidden
          - name: date_deadline
          - name: claim_id
          - name: content_owner
          - name: upc
          - name: isrc
          - name: track
          - name: artist
          - name: album
          - name: label_id
          - name: label_name
          - name: imprint
          - name: label_client_manager
          - name: label_priority
          - name: notes
          - name: strikes
          - name: claimant
          - name: claimant_contact
          - name: claimant_email
          - name: asserted_territory
          - name: claim_type
          - name: status
          - name: resolution
          - name: comments

      - name: spotify_hides
        columns:
          - name: claim_initiated
          - name: claim_id
          - name: content_owner
          - name: release
          - name: artist
          - name: upc
          - name: isrc
          - name: track
          - name: track_artist
          - name: claimant
          - name: claimant_contact
          - name: claimant_email
          - name: asserted_territory
          - name: claim_type
          - name: is_there_a_strike_on_this_content_already
          - name: is_there_a_strike_on_this_label_imprint_already
          - name: if_yes_how_many
          - name: label
          - name: label_id
          - name: imprint
          - name: cm
          - name: deadline
          - name: status
          - name: resolution___strikes_issued
          - name: initals
          - name: comments

      - name: spotify_strikes
        columns:
          - name: parent_label
          - name: label_id
          - name: imprint
          - name: no__of_strike
          - name: notes_from_legal

      - name: spotify_strikes_view
        columns:
          - name: label_id
          - name: imprint
          - name: label_name
          - name: strikes
          - name: label_priority
          - name: label_client_manager