label: "Performance Rights"
connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

explore: int_prod_vw_performance_rights_delivery_history {
  label: "Delivery History"
  view_label: "Delivery History"

  join: orch_app_ar_track {
    view_label: "Track"
    type: inner
    sql_on: ${int_prod_vw_performance_rights_delivery_history.tuid} = ${orch_app_ar_track.tuid} ;;
    relationship: many_to_one
    fields: [tuid, isrc, track_name]
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    type: inner
    sql_on: ${orch_app_ar_track.release_id} = ${orch_app_ar_releases.release_id} ;;
    relationship: many_to_one
    fields: [upc, release_name]
  }

  join: orch_app_ar_artist_info {
    view_label: "Artist"
    type: inner
    sql_on: ${orch_app_ar_releases.artist_id} = ${orch_app_ar_artist_info.artist_id} ;;
    relationship: many_to_one
    fields: [artist_id, name]
  }

  join: orch_app_ar_subaccount {
    view_label: "Subaccount"
    type: left_outer
    sql_on: ${orch_app_ar_releases.subaccount_id} = ${orch_app_ar_subaccount.subaccount_id} ;;
    relationship: many_to_one
    fields: [subaccount_id, subaccount_name]
  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    type: inner
    sql_on: ${int_prod_vw_performance_rights_delivery_history.label_id} = ${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    fields: [vendor_id, label_name]
  }
}