label: "KNR Models"
connection: "knr-looker"

include: "/views/chartmetric_itunes.view.lkml"
include: "/views/chartmetric_recordings.view.lkml"
include: "/views/global_countries.view.lkml"

explore: chartmetric_itunes {
  hidden: no
  label: "Chartmetric iTunes Performance"
  description: "Analytics hub tracking iTunes track attributes, digital storefront entries, and album sales profiles mapped back to the global directory."

  join: chartmetric_recordings {
    type: left_outer
    relationship: many_to_many
    sql_on: LOWER(${chartmetric_itunes.isrc}) = LOWER(${chartmetric_recordings.isrc}) ;;
  }

  join: global_countries {
    type: left_outer
    relationship: many_to_one
    sql_on: UPPER(${chartmetric_itunes.storefront}) = UPPER(${global_countries.country_code}) ;;
  }
}