label: "Operations"
connection: "snowflake_via_lookerappadmin"

include: "meta_update_queue.view.lkml"
include: "meta_update_dms_master.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_country.view.lkml"
include: "orch_app_ar_track.view.lkml"
include: "facts_prod_dim_label.view.lkml"
include: "int_prod_vw_restrictions_release_store.view.lkml"
include: "orch_app_ar_product_type.view.lkml"
include: "orch_app_ar_distribution_format.view.lkml"
include: "orch_app_ar_distribution_format_media.view.lkml"
include: "int_prod_vw_restrictions_release_territory.view.lkml"
include: "orch_app_ar_customer_master_master.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"
include: "orch_app_ar_orchadmin_users.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "int_prod_vw_restrictions_label_store.view.lkml"
include: "int_prod_vw_restrictions_label_substore.view.lkml"
include: "int_prod_vw_restrictions_release_substore.view.lkml"
include: "int_prod_vw_restrictions_label_territory.view.lkml"
include: "int_prod_vw_restrictions_subaccount_store.view.lkml"
include: "orch_app_ar_subaccount.view.lkml"
include: "dt_video_product_builder.view.lkml"

explore: meta_update_queue {
  label: "Meta Update Queue"
  case_sensitive: no
  hidden: yes

  join: meta_update_dms_master{
    type: inner
    sql_on: ${meta_update_dms_master.meta_update_queue_id}=${meta_update_queue.meta_update_queue_id} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_customer_master_master{
    view_label: "Store"
    sql_on: ${meta_update_dms_master.customer_master_master_id}=${orch_app_ar_customer_master_master.customer_master_master_id} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${meta_update_queue.upc}=${orch_app_ar_releases.upc} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_product_type {
    view_label: "Product Type"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.product_type_id} = ${orch_app_ar_product_type.product_type_id} ;;
  }

  join: orch_app_ar_distribution_format {
    view_label: "Distribution Format"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.distribution_format_id} = ${orch_app_ar_distribution_format.distribution_format_id} ;;
  }

  join: orch_app_ar_distribution_format_media {
    view_label: "Distribution Format"
    relationship: many_to_one
    sql_on: ${orch_app_ar_distribution_format.distribution_format_media_id} = ${orch_app_ar_distribution_format_media.distribution_format_media_id} ;;
  }

  join: int_prod_vw_restrictions_release_store {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_store.release_id} ;;
    relationship: one_to_many
    }

  join: int_prod_vw_restrictions_release_territory {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_territory.release_id} ;;
    relationship: one_to_many
  }

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


  join: orch_app_ar_country {
    view_label: "Artist Country"
    sql_on: ${orch_app_ar_country.id}=${orch_app_ar_artist_info.orchard_country} ;;
    relationship: many_to_one
    fields: [orch_app_ar_country.name, orch_app_ar_country.continent]
  }

  join: orch_app_ar_vendor {
    sql_on: ${orch_app_ar_artist_info.vendor_id}=${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    fields: []
  }

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

  join: ops_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Meta Update Queue"
    sql_on:${meta_update_queue.orchadmin_user_id}=${ops_manager.id}  ;;
    fields: [ops_manager.orchadmin_user]
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    sql_on: ${orch_app_ar_artist_info.vendor_id}=${facts_prod_dim_label.label_id} ;;
    relationship: many_to_one
    fields: [facts_prod_dim_label.label_id,facts_prod_dim_label.label_name]
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label Country"
    sql_on: ${orch_app_ar_country.id}=${label_country.id}} ;;
    relationship: many_to_one
    fields: [name, continent]
  }

  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
  }

  join: int_prod_vw_restrictions_label_store {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${facts_prod_dim_label.label_id} = ${int_prod_vw_restrictions_label_store.label_id} ;;
  }

  join: int_prod_vw_restrictions_label_substore {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${facts_prod_dim_label.label_id} = ${int_prod_vw_restrictions_label_substore.label_id} ;;
  }

  join: int_prod_vw_restrictions_release_substore {
    view_label: "Release"
    relationship: one_to_many
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_substore.release_id} ;;
  }

  join: int_prod_vw_restrictions_label_territory {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${facts_prod_dim_label.label_id} = ${int_prod_vw_restrictions_label_territory.label_id} ;;
  }

  join: orch_app_ar_subaccount {
    view_label: "Subaccount"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.subaccount_id} = ${orch_app_ar_subaccount.subaccount_id}
      AND ${orch_app_ar_vendor.vendor_id} = ${orch_app_ar_subaccount.vendor_id} ;;
  }

  join: int_prod_vw_restrictions_subaccount_store {
    view_label: "Subaccount"
    relationship: one_to_many
    sql_on: ${orch_app_ar_subaccount.subaccount_id} = ${int_prod_vw_restrictions_subaccount_store.subaccount_id} ;;
  }

  join: dt_video_product_builder {
    view_label: "Release"
    relationship: many_to_many
    sql_on: ${meta_update_queue.upc} = ${dt_video_product_builder.upc} ;;
    fields: [dt_video_product_builder.channel_selection]
  }

}