label: "Label Streaming Anomalies - Monthly"
connection: "snowflake_via_lookerappadmin"
include: "/views/label_streaming_anomalies/*.view.lkml"
include: "/facts_prod_dim_release.view.lkml"
include: "/facts_prod_dim_track.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: int_dbt_prod_label_anomalies_monthly {
  label: "Label Streaming Anomalies"
  case_sensitive: no
  hidden: no

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_many
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_label_anomalies_monthly.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: int_dbt_prod_label_country_monthly_ctc {
  label: "Country Monthly CTC"
  case_sensitive: no
  hidden: no
}

explore: int_dbt_prod_label_store_monthly_ctc {
  label: "Store Monthly CTC"
  case_sensitive: no
  hidden: no
}

explore: int_dbt_prod_label_artist_monthly_ctc {
  label: "Artist Monthly CTC"
  case_sensitive: no
  hidden: no
}

explore: int_dbt_prod_label_source_monthly_ctc {
  label: "Source Monthly CTC"
  case_sensitive: no
  hidden: no
}

explore: int_dbt_prod_label_upc_monthly_ctc {
  label: "UPC Monthly CTC"
  case_sensitive: no
  hidden: no

  join: facts_prod_dim_release {
    sql_on: ${facts_prod_dim_release.upc} = ${int_dbt_prod_label_upc_monthly_ctc.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: many_to_one
    view_label: "Artist"
  }
}

explore: int_dbt_prod_label_isrc_monthly_ctc {
  label: "ISRC Monthly CTC"
  case_sensitive: no
  hidden: no

  # join: facts_prod_dim_track {
  #   sql_on: ${facts_prod_dim_track.isrc} = ${int_dbt_prod_label_isrc_monthly_ctc.isrc} ;;
  #   relationship: one_to_one
  # }
}