connection: "youtube-looker"

include: "/views/facts_prod_staging_raw_youtube_asset_conflict.view"
include: "/views/orch_app_ar_track.view.lkml"
include: "/views/orch_app_ar_releases.view.lkml"
include: "/views/orch_app_ar_artist_info.view.lkml"
include: "/views/orch_app_ar_vendor.view.lkml"
include: "/views/orch_app_ar_subaccount.view.lkml"
include: "/views/facts_prod_dim_label.view"
include: "/views/facts_prod_fact_conflict.view"
include: "/views/int_dbt_prod_awal_tier_groups.view.lkml"


explore: facts_prod_staging_raw_youtube_asset_conflict {
  label: "YouTube Asset Conflict"
  description: "Explore for YouTube Asset Conflict Reporting"

  join: orch_app_ar_track {
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_youtube_asset_conflict.isrc} = ${orch_app_ar_track.isrc}
      AND LTRIM(TO_VARCHAR(${orch_app_ar_track.upc}),0) = LTRIM(TO_VARCHAR(${facts_prod_staging_raw_youtube_asset_conflict.upc}),0) ;;
  }

  join: orch_app_ar_releases {
    relationship: many_to_one
    sql_on: LTRIM(TO_VARCHAR(${facts_prod_staging_raw_youtube_asset_conflict.upc}),0) = LTRIM(TO_VARCHAR(${orch_app_ar_releases.upc}),0);;
  }

  join: orch_app_ar_artist_info {
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.artist_id} = ${orch_app_ar_artist_info.artist_id} ;;
  }

  join: facts_prod_dim_label {
    relationship: many_to_one
    sql_on: ${orch_app_ar_artist_info.vendor_id} = ${facts_prod_dim_label.label_id} ;;
  }

  join: orch_app_ar_subaccount {
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.subaccount_id} = ${orch_app_ar_subaccount.subaccount_id} ;;
  }

  join: facts_prod_fact_conflict {
    relationship: many_to_one
    sql_on: ${facts_prod_fact_conflict.tuid} = ${orch_app_ar_track.tuid} ;;
  }

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