connection: "youtube-looker"

include: "/views/facts_prod_staging_raw_youtube_monthly_claim.view.lkml"
include: "/views/dt_youtube_multi_asset_isrc_join.view.lkml"
include: "/views/orch_app_ar_releases.view.lkml"
include: "/views/orch_app_ar_track.view.lkml"

explore: facts_prod_staging_raw_youtube_monthly_claim {
  label: "YouTube Monthly Claim Raw Data"
  case_sensitive: no
  hidden: yes

  join: orch_app_ar_releases {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_youtube_monthly_claim.upc} = to_varchar(${orch_app_ar_releases.upc});;
    fields: [orch_app_ar_releases.release_name, orch_app_ar_releases.release_date]
  }

  join: orch_app_ar_track {
    view_label: "Metadata"
    relationship: many_to_one
    sql_on: ${facts_prod_staging_raw_youtube_monthly_claim.isrc} = ${orch_app_ar_track.isrc} and ${facts_prod_staging_raw_youtube_monthly_claim.upc} = to_varchar(${orch_app_ar_track.upc});;
    fields: [orch_app_ar_track.track_name]
  }
}

explore: dt_youtube_multi_asset_isrc_join {
  label: "YouTube Multi Asset ISRC Data"
  case_sensitive: no
  hidden: yes

  join: orch_app_ar_releases {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${dt_youtube_multi_asset_isrc_join.upc} = to_varchar(${dt_youtube_multi_asset_isrc_join.upc});;
    fields: [orch_app_ar_releases.release_name, orch_app_ar_releases.release_date]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${dt_youtube_multi_asset_isrc_join.isrc} = ${orch_app_ar_track.isrc} and ${dt_youtube_multi_asset_isrc_join.upc} = to_varchar(${orch_app_ar_track.upc});;
    fields: [orch_app_ar_track.track_name]
  }
}