connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_weekly_trending_tracks_uk_spotify.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.view.lkml"
include: "int_dbt_prod_spotify_3rd_party_playlist_spt_last_week.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_amazon.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_amazon_collection.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_genre.view.lkml"
include: "orch_app_ar_country.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_amazon_user_playlist.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_amazon_long_tail.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple_library_streams.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple_long_tail.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple_search_streams.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple_voice_streams.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_apple_discovery_streams.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_spotify_continent.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_combined_tiktok.view.lkml"
include: "facts_prod_dim_track.view.lkml"
include: "facts_prod_dim_release.view.lkml"
include: "facts_prod_dim_artist.view.lkml"
include: "int_dbt_prod_weekly_trending_genres_spotify.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_awa.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_deezer.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_line.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_pandora.view.lkml"
include: "int_dbt_prod_weekly_trending_tracks_soundcloud.view.lkml"
include: "orch_app_ar_release_subgenre.view.lkml"
include: "orch_app_ar_subgenre.view.lkml"
include: "orch_app_ar_track.view.lkml"
include: "orch_app_ar_orchadmin_users.view.lkml"



explore: int_dbt_prod_weekly_trending_tracks_uk_spotify {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_uk_spotify.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_uk_spotify.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }

  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: 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} ;;
  }

}

explore: int_dbt_prod_weekly_trending_tracks_uk_spotify_collection {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_collection.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }

}

explore: int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_3rdparty_and_user_playlist.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }

}

explore: int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_lean_fwd.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }

}

explore: int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_uk_spotify_long_tail.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }

}

explore: int_dbt_prod_spotify_3rd_party_playlist_spt_last_week {
  hidden: yes
  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_spotify_3rd_party_playlist_spt_last_week.transaction_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }
}

explore: int_dbt_prod_weekly_trending_tracks_amazon {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_amazon.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_amazon.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_amazon.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_amazon_collection {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_amazon_collection.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_amazon_collection.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_amazon_collection.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_amazon_lean_fwd.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

  }

explore: int_dbt_prod_weekly_trending_tracks_amazon_user_playlist {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_amazon_user_playlist.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_amazon_user_playlist.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_amazon_user_playlist.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_amazon_long_tail {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_amazon_long_tail.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_amazon_long_tail.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_amazon_long_tail.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_apple {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_apple_discovery_streams {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple_discovery_streams.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple_discovery_streams.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple_discovery_streams.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_apple_library_streams {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple_library_streams.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple_library_streams.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple_library_streams.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_apple_long_tail {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple_long_tail.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple_long_tail.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple_long_tail.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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



}

explore: int_dbt_prod_weekly_trending_tracks_apple_search_streams {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple_search_streams.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple_search_streams.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple_search_streams.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_apple_voice_streams {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_apple_voice_streams.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_apple_voice_streams.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_apple_voice_streams.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_spotify_continent {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_spotify_continent.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_spotify_continent.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }


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

  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: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.upc} = ${int_dbt_prod_weekly_trending_tracks_spotify_continent.upc} and ${orch_app_ar_track.isrc} = ${int_dbt_prod_weekly_trending_tracks_spotify_continent.isrc}  ;;
    type: inner
    fields: [orch_app_ar_track.track_version]
  }
}

explore: int_dbt_prod_weekly_trending_tracks_combined_tiktok {
  hidden: yes

  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_combined_tiktok.labelid} ;;
    relationship: one_to_many
  }

  join: facts_prod_dim_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_weekly_trending_tracks_combined_tiktok.isrc} = ${facts_prod_dim_track.isrc} and ${int_dbt_prod_weekly_trending_tracks_combined_tiktok.upc} = ${facts_prod_dim_track.upc};;
    fields: [
      track_id,
      track_unique_id,
      track_name,
      duration
    ]
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_combined_tiktok.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_weekly_trending_tracks_combined_tiktok.transaction_country_code} = ${transaction_country.country_code} ;;
    fields: [name]
  }


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

  join: facts_prod_dim_release {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_weekly_trending_tracks_combined_tiktok.upc} = ${facts_prod_dim_release.upc}


      ;;
    fields: []
  }



  join: facts_prod_dim_artist {
    view_label: "Artist"
    relationship: many_to_one
    sql_on: ${facts_prod_dim_release.artist_id} = ${facts_prod_dim_artist.artist_id} ;;
    fields: [
      artist_name
    ]
  }

}

explore: int_dbt_prod_weekly_trending_genres_spotify {
  hidden: yes

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_weekly_trending_genres_spotify.user_country_code} = ${transaction_country.country_code} ;;
    fields: [name]
  }



}

explore: int_dbt_prod_weekly_trending_tracks_awa {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_awa.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_awa.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_awa.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_deezer {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_deezer.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_deezer.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_deezer.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

explore: int_dbt_prod_weekly_trending_tracks_line {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_line.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_line.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_line.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

explore: int_dbt_prod_weekly_trending_tracks_pandora {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_pandora.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_pandora.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_pandora.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}

explore: int_dbt_prod_weekly_trending_tracks_soundcloud  {
  hidden: yes
  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_weekly_trending_tracks_soundcloud.labelid} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_weekly_trending_tracks_soundcloud.upc} ;;
    relationship: one_to_many
  }

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

  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]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_weekly_trending_tracks_soundcloud.country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

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

}