connection: "snowflake_via_lookerappadmin"
include: "facts_prod_staging_raw_mrc.view.lkml"
include: "facts_prod_staging_raw_mrc_artist_mapping.view.lkml"
include: "cm_social_current.view.lkml"
include: "cm_spotify_change.view.lkml"
label: "MRC"

explore: facts_prod_staging_raw_mrc {
  hidden: yes
  label: "MRC A&R"
  view_label: "MRC Report"

  join: facts_prod_staging_raw_mrc_artist_mapping {
    sql_on: ${facts_prod_staging_raw_mrc_artist_mapping.unified_artist_id} = ${facts_prod_staging_raw_mrc.primary_artist} ;;
    type: inner
    view_label: "Artist Mapping"
    }

  join: cm_social_current {
    sql_on: UPPER(${cm_social_current.name}) = UPPER(${facts_prod_staging_raw_mrc_artist_mapping.unified_artist_name}) ;;
    type: left_outer
    view_label: "Chart Metric"
  }

  join: cm_spotify_change {
    sql_on: UPPER(${cm_spotify_change.name}) = UPPER(${facts_prod_staging_raw_mrc_artist_mapping.unified_artist_name}) ;;
    type: left_outer
    view_label: "Chart Metric"
  }

}