connection: "youtube-looker"
label: "YouTube"
include: "/views/facts_prod_fact_youtube_asset_analytics.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"
include: "/views/facts_prod_dim_genre.view.lkml"
include: "/views/facts_prod_dim_store.view.lkml"
include: "/views/facts_prod_dim_feed.view.lkml"
include: "/views/facts_prod_dim_track.view.lkml"
include: "/views/orch_app_ar_track.view.lkml"
include: "/views/orch_app_ar_releases.view.lkml"
include: "/views/dt_track_artist_by_type.view.lkml"
include: "/views/facts_prod_dim_artist.view.lkml"
include: "/views/facts_prod_dim_label.view.lkml"
include: "/views/facts_prod_dim_imprint.view.lkml"
include: "/views/facts_prod_dim_catalog.view.lkml"
include: "/views/int_dev_skeels_youtube_channel_mappings.view.lkml"
include: "/views/facts_prod_dim_licensor.view.lkml"
include: "/views/int_dbt_prod_awal_tier_groups.view.lkml"
include: "/views/orch_app_ar_vendor.view.lkml"
include: "/views/orch_app_ar_orchadmin_users.view.lkml"
include: "/views/orch_app_ar_subaccount.view.lkml"

explore: facts_prod_fact_youtube_asset_analytics {
  hidden: no
  label: "YouTube Asset Analytics"
  view_label: "Assets"


  join: facts_prod_dim_country {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.activitycountryid} =
      ${facts_prod_dim_country.country_id};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_country.country_name]
  }

  join: facts_prod_dim_genre {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.genreid} =
      ${facts_prod_dim_genre.genre_id};;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_genre.genre]
  }

  join: facts_prod_dim_store {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.storeid} =
      ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_store.store_name]
  }

  join: facts_prod_dim_feed {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.feedid} =
      ${facts_prod_dim_feed.feedid} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_feed.feedname]
  }

  join: facts_prod_dim_track {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.trackid} =
      ${facts_prod_dim_track.track_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_track.track_name, facts_prod_dim_track.isrc]
  }

  join: orch_app_ar_track {
    sql_on: ${facts_prod_dim_track.track_unique_id} = ${orch_app_ar_track.tuid}  ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [orch_app_ar_track.tuid]
  }

  join: orch_app_ar_releases {
    sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_track.release_id}  ;;
    relationship: one_to_many
    view_label: "Release"
    fields: [orch_app_ar_releases.upc, orch_app_ar_releases.release_name]
  }

  join: orch_app_ar_subaccount {
    sql_on: ${orch_app_ar_releases.subaccount_id} = ${orch_app_ar_subaccount.subaccount_id};;
  relationship: many_to_one
  view_label: "Metadata"
  fields: [orch_app_ar_subaccount.subaccount_id, orch_app_ar_subaccount.subaccount_name]
}

  join: dt_track_artist_by_type {
    relationship: one_to_one
    view_label: "Metadata"
    sql_on: ${orch_app_ar_track.tuid} = ${dt_track_artist_by_type.tuid} ;;
  }

  join: facts_prod_dim_artist {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.artistid} =
      ${facts_prod_dim_artist.artist_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_artist.artist_name]
  }

  join: facts_prod_dim_label {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.labelid} =
      ${facts_prod_dim_label.label_id} ;;
    relationship: many_to_one
    view_label: "Label"
    fields: [facts_prod_dim_label.label_name]
  }

  join: facts_prod_dim_imprint {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.imprintid} =
      ${facts_prod_dim_imprint.imprint_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_imprint.imprint_name]
  }

  join: facts_prod_dim_catalog {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.catalogid} =
      ${facts_prod_dim_catalog.catalog_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [facts_prod_dim_catalog.catalog_name]
  }

  join: int_dev_skeels_youtube_channel_mappings {
    sql_on: ${facts_prod_fact_youtube_asset_analytics.channelid} =
      ${int_dev_skeels_youtube_channel_mappings.channel_id} ;;
    relationship: many_to_one
    view_label: "Metadata"
    fields: [int_dev_skeels_youtube_channel_mappings.public_name]
  }

  join: facts_prod_dim_licensor {
    view_label: "Licensor"
    relationship: many_to_one
    sql_on: ${facts_prod_fact_youtube_asset_analytics.licensorid}= ${facts_prod_dim_licensor.licensorid};;
    fields: [facts_prod_dim_licensor.licensorname,facts_prod_dim_licensor.distributor]
  }

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

  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    sql_on: ${facts_prod_dim_label.label_id} =${orch_app_ar_vendor.vendor_id};;
    relationship: many_to_one
    fields: []
  }

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

}