connection: "snowflake_via_lookerappadmin"
label: "Analytics Models - Store Level"

include: "int_dbt_prod_agg_netease_model.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "orch_app_ar_orchadmin_users.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_genre.view.lkml"
include: "orch_app_ar_release_subgenre.view.lkml"
include: "orch_app_ar_subgenre.view.lkml"
include: "orch_app_ar_country.view.lkml"


explore: int_dbt_prod_agg_netease_model {
  label: "Netease Store Model"
  view_label: "Aggregated Netease Model"
  hidden: no
  fields: [
    ALL_FIELDS*
  ]
  case_sensitive: no

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_agg_netease_model.labelid}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_agg_netease_model.labelid};;
    relationship: many_to_one
    fields: [vendor_id,label_name]
  }

  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: orch_app_ar_releases {
    view_label: "Release"
    relationship: one_to_one
    sql_on: cast(${orch_app_ar_releases.upc} as varchar) = ${int_dbt_prod_agg_netease_model.upc} ;;
    fields: []
  }

  join: orch_app_ar_genre {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.release_genre_id} = ${orch_app_ar_genre.genre_id} ;;
  }

  join: orch_app_ar_release_subgenre {
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_release_subgenre.release_id} ;;
    fields: []
  }

  join: orch_app_ar_subgenre {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${orch_app_ar_release_subgenre.subgenre_id} = ${orch_app_ar_subgenre.subgenre_id} ;;
  }


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

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

}