connection: "snowflake_via_lookerappadmin"

include: "/views/label_contribution_to_change/label_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_country_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_artist_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_store_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_source_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_release_level_contribution_to_change.view.lkml"
include: "/views/label_contribution_to_change/label_track_level_contribution_to_change.view.lkml"
include: "/facts_prod_dim_release.view.lkml"
include: "/facts_prod_dim_artist.view.lkml"
include: "/orch_app_ar_vendor.view.lkml"
include: "/orch_app_ar_orchadmin_users.view.lkml"

explore: label_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

}

explore: label_country_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_country_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

}

explore: label_artist_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_artist_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

}

explore: label_store_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_store_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

}

explore: label_source_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_source_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

}

explore: label_release_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_release_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

  join: facts_prod_dim_release {
    sql_on: ${facts_prod_dim_release.upc} = ${label_release_level_contribution_to_change.upc} ;;
    relationship: one_to_one
    view_label: "Release"
  }
}

explore: label_track_level_contribution_to_change {

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${label_track_level_contribution_to_change.label_id} ;;
    type: inner
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

  join: facts_prod_dim_release {
    sql_on: ${facts_prod_dim_release.upc} = ${label_track_level_contribution_to_change.upc} ;;
    relationship: one_to_one
    view_label: "Release"
  }

  join: facts_prod_dim_artist {
  sql_on: ${facts_prod_dim_artist.artist_id} = ${facts_prod_dim_release.artist_id} ;;
  relationship: one_to_many
  view_label: "Artist"
  }

}