label: "KNR Models"
connection: "knr-looker"

# Core Configuration & Customer Masters
include: "/views/customer_master_master.view.lkml"
include: "/views/global_countries.view.lkml"

# Delivery App Core Ingestion Workflow Views
include: "/views/performance_delivery_claiming_order.view.lkml"
include: "/views/performance_delivery_claiming_job.view.lkml"
include: "/views/performance_delivery_claims.view.lkml"
include: "/views/performance_delivery_queue.view.lkml"

include: "/views/performance_nr_contribution.view.lkml"
include: "/views/performance_nr_contributor.view.lkml"
include: "/views/performance_nr_particpant.view.lkml"
include: "/views/performance_nr_sound_recording.view.lkml"
include: "/views/nr_sound_recording_has_featured_artist_nr_participant.view.lkml"
include: "/views/nr_sound_recording_has_primary_artist_nr_participant.view.lkml"
include: "/views/nr_contribution_contributed_to_nr_sound_recording.view.lkml"
include: "/views/nr_contribution_type.view.lkml"

# =========================================================================

# EXPLORE: PERFORMANCE DELIVERY WORKFLOW MATRIX (FULLY UNIFIED)
# =========================================================================
explore: performance_delivery_claiming_order {
  hidden: no
  label: "Performance Delivery Workflow"
  view_name: performance_delivery_claiming_order

  # 1. Join Master Customer Directory
  join: customer_master_master {
    type: left_outer
    relationship: many_to_one
    sql_on: ${performance_delivery_claiming_order.customer_master_master_id} = ${customer_master_master.customer_master_master_id} ;;
  }

  # 2. Join Jobs to Orders
  join: performance_delivery_claiming_job {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performance_delivery_claiming_order.id} = ${performance_delivery_claiming_job.order_id} ;;
  }

  # 3. Join Claims to Jobs
  join: performance_delivery_claims {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performance_delivery_claiming_job.id} = ${performance_delivery_claims.job_id} ;;
  }

  # 4. Bridge Claims to Core Performer Catalog Records
  join: performance_nr_contribution {
    type: left_outer
    relationship: many_to_one
    sql_on: ${performance_delivery_claims.contribution_uuid} = ${performance_nr_contribution.id} ;;
  }

  # =========================================================================
  # 🌟 NEWLY INJECTED: LIVE INGESTION QUEUE SYSTEM JOIN
  # =========================================================================
  # Tying the queue data directly into your catalog path via the contribution ID bridge
  join: performance_delivery_queue {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performance_nr_contribution.id} = ${performance_delivery_queue.contribution_uuid} ;;
  }

  # 5. Link Contribution to Contribution Type
  join: nr_contribution_type {
    type: left_outer
    relationship: many_to_one
    sql_on: ${performance_nr_contribution.id} = ${nr_contribution_type.nr_contribution_id} ;;
  }

  # 6. Link Contribution Type to Contributor
  join: performance_nr_contributor {
    type: left_outer
    relationship: many_to_one
    sql_on: ${nr_contribution_type.nr_contributor_id} = ${performance_nr_contributor.id} ;;
  }

  # 7. Join Contribution to the Sound Recording Bridge Table
  join: nr_contribution_contributed_to_nr_sound_recording {
    type: left_outer
    relationship: many_to_one
    sql_on: ${performance_nr_contribution.id} = ${nr_contribution_contributed_to_nr_sound_recording.nr_contribution_id} ;;
  }

  # 8. Join Bridge Table to the Sound Recording
  join: performance_nr_sound_recording {
    type: left_outer
    relationship: many_to_one
    sql_on: ${nr_contribution_contributed_to_nr_sound_recording.nr_sound_recording_id} = ${performance_nr_sound_recording.id} ;;
  }

  # 9. Join Sound Recording to Featured Artist Bridge Table
  join: nr_sound_recording_has_featured_artist_nr_participant {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performance_nr_sound_recording.id} = ${nr_sound_recording_has_featured_artist_nr_participant.nr_sound_recording_id} ;;
  }

  # 10. Join Sound Recording to Primary Artist Bridge Table
  join: nr_sound_recording_has_primary_artist_nr_participant {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performance_nr_sound_recording.id} = ${nr_sound_recording_has_primary_artist_nr_participant.nr_sound_recording_id} ;;
  }

  # --- ALIASED PARTICIPANT REGISTRY TARGETS ---

  # 11a. Featured Artist Participant
  join: featured_artist_participant {
    from: performance_nr_particpant
    view_label: "Featured Artist Participant"
    type: left_outer
    relationship: many_to_one
    sql_on: ${nr_sound_recording_has_featured_artist_nr_participant.nr_participant_id} = ${featured_artist_participant.id} ;;
  }

  # 11b. Primary Artist Participant
  join: primary_artist_participant {
    from: performance_nr_particpant
    view_label: "Primary Artist Participant"
    type: left_outer
    relationship: many_to_one
    sql_on: ${nr_sound_recording_has_primary_artist_nr_participant.nr_participant_id} = ${primary_artist_participant.id} ;;
  }
}