connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

explore: orch_app_ar_vendor {
  hidden: yes
  view_label: "Label"

  #join: active_label {
  #  from: int_prod_vw_active_vendor_contract
  #  relationship: one_to_one
  #  sql_on: ${orch_app_ar_vendor.vendor_id} = ${active_label.vendor_id} ;;
  #  fields: [active_label]
  #}

  join: orch_app_ar_artist_info {
    view_label: "Artist"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${orch_app_ar_artist_info.vendor_id} ;;
    type: inner
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    relationship: one_to_many
    sql_on: ${orch_app_ar_artist_info.artist_id} = ${orch_app_ar_releases.artist_id} ;;
    type: inner
  }

  join: dt_bits_per_sample {
    view_label: "Bits Per Sample"
    sql_on: ${orch_app_ar_releases.upc}=${dt_bits_per_sample.upc} ;;
    relationship: one_to_one
  }

  join: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.release_id} = ${orch_app_ar_releases.release_id} ;;
    type: inner
  }

}