connection: "snowflake_via_lookerappadmin"

include: "stream_share_spotify_weekly.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"

explore: stream_share_spotify_weekly {
  label: "Last Week Spotify Markest Share"
  view_label: "Market Share"
  case_sensitive: no
  hidden: yes

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

  }
}