label: "Video Product Builder"
connection: "snowflake_via_lookerappadmin"

include: "dt_video_product_builder.view.lkml"
include: "dt_agg_restrictions_release_territory.view.lkml"
include: "facts_prod_dim_genre.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_mkt_priority.view.lkml"
include: "orch_app_ar_track.view.lkml"
include: "orch_app_ar_track_video.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"
include: "/views/orch_app_ar_product_video_approval.view.lkml"
include: "/dt_blocklist_artist_with_reason.view.lkml"
include: "int_dbt_prod_product_manager_mapping_union.view.lkml"
include: "/orch_app_ar_vendor.view.lkml"
include: "/orch_app_ar_orchadmin_users.view.lkml"

explore: dt_video_product_builder {
  label: "Video Product Builder"
  view_label: "Video Product Builder"
  hidden: no
  case_sensitive: no

  join: dt_agg_restrictions_release_territory {
    view_label: "Release Restrictions (Country)"
    relationship: one_to_one
    sql_on: ${dt_video_product_builder.release_id} = ${dt_agg_restrictions_release_territory.release_id} ;;
  }

  join: orch_app_ar_releases {
    view_label: "Video Product Builder"
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.release_id} = ${dt_video_product_builder.release_id};;
    fields: [orch_app_ar_releases.is_active,orch_app_ar_releases.release_id ]
  }

  join: facts_prod_dim_genre {
    view_label: "Video Product Builder"
    relationship: many_to_many
    sql_on: ${facts_prod_dim_genre.genre_id} = ${dt_video_product_builder.genre_id} ;;
    fields: [facts_prod_dim_genre.genre]
  }

  join: orch_app_ar_mkt_priority {
    view_label: "Video Product Builder"
    relationship: one_to_many
    sql_on: ${orch_app_ar_mkt_priority.release_id} = ${dt_video_product_builder.release_id} ;;
    fields: [orch_app_ar_mkt_priority.priority]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    relationship: one_to_one
    sql_on: ${dt_video_product_builder.upc} = ${orch_app_ar_track.upc} and ${dt_video_product_builder.isrc} = ${orch_app_ar_track.isrc} ;;
    fields: [orch_app_ar_track.offer_type, orch_app_ar_track.explicit_lyrics, orch_app_ar_track.duration,
      orch_app_ar_track.duration_in_minutes, orch_app_ar_track.duration_in_seconds, orch_app_ar_track.preview_start_time,
      orch_app_ar_track.closed_caption_exists,orch_app_ar_track.stereo_or_mono ]
  }

  join: orch_app_ar_track_video {
    view_label: "Track Video"
    relationship: one_to_one
    sql_on: ${orch_app_ar_track.tuid} = ${orch_app_ar_track_video.id} ;;
  }

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

  }

  join: orch_app_ar_product_video_approval {
    view_label: "Video Product Builder"
    relationship: one_to_one
    sql_on: ${dt_video_product_builder.release_id} = ${orch_app_ar_product_video_approval.release_id};;
  }

  join: dt_blocklist_artist_with_reason {
    view_label: "Artist Blocklist"
    relationship: one_to_one
    sql_on: UPPER(${dt_video_product_builder.artist_name}) = UPPER(${dt_blocklist_artist_with_reason.blocklist_artist});;
  }

  join: int_dbt_prod_product_manager_mapping_union {
    view_label: "Video Product Builder"
    relationship: many_to_one
    sql_on: NULLIF(CAST(${dt_video_product_builder.upc} AS VARCHAR), '') = NULLIF(CAST(${int_dbt_prod_product_manager_mapping_union.upc} AS VARCHAR), '') ;;
    fields: [int_dbt_prod_product_manager_mapping_union.product_manager]
  }

  join: orch_app_ar_vendor {
    relationship: many_to_one
    sql_on: ${dt_video_product_builder.label_id} = ${orch_app_ar_vendor.vendor_id} ;;
    fields: []
  }

join: quarterback_label_manager {
  from: orch_app_ar_orchadmin_users
  view_label: "Video Product Builder"
  relationship: many_to_one
  sql_on: CAST(${orch_app_ar_vendor.quarterback_label_manager} AS VARCHAR) = CAST(${quarterback_label_manager.id} AS VARCHAR) ;;
  fields: [quarterback_label_manager.orchadmin_user]
}

join: assigned_reviewer {
  from: orch_app_ar_orchadmin_users
  view_label: "Video Product Builder"
  relationship: many_to_one
  sql_on: CAST(${orch_app_ar_vendor.assigned_reviewer} AS VARCHAR) = CAST(${assigned_reviewer.id} AS VARCHAR) ;;
  fields: [assigned_reviewer.orchadmin_user]
}

  }