view: ownership_delivery_job_contents {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.JOB_CONTENTS ;;

  # =========================================================================
  # 1. PRIMARY KEYS & CORE LINKS
  # =========================================================================
  dimension: fivetran_id {
    primary_key: yes
    type: string
    sql: ${TABLE}._FIVETRAN_ID ;;
    hidden: yes
  }

  dimension: job_id {
    type: number
    sql: ${TABLE}.JOB_ID ;;
    label: "Job ID Link"
    description: "Foreign key linking straight up to ownership_delivery_jobs.id."
  }

  dimension: sound_recording_id {
    type: string
    sql: ${TABLE}.SOUND_RECORDING_ID ;;
    label: "Sound Recording ID Link"
    description: "Foreign key pointing back to your central Sound Recording spoke view catalog."
  }

  dimension: track_id {
    type: string
    sql: ${TABLE}.TRACK_ID ;;
    label: "Track ID Link"
    group_label: "Alternative Content Identifiers"
    description: "Secondary operational platform identifier associated with the recording metadata row."
  }

  # =========================================================================
  # 2. SYSTEM METADATA LOGS & TIMESTAMPS (Hidden)
  # =========================================================================
  dimension: _fivetran_index { type: number sql: ${TABLE}._FIVETRAN_INDEX ;; group_label: "System Metadata" hidden: yes }
  dimension: _fivetran_deleted { type: yesno sql: ${TABLE}._FIVETRAN_DELETED ;; group_label: "System Metadata" hidden: yes }
  dimension_group: _fivetran_synced { type: time timeframes: [raw, date] datatype: timestamp sql: ${TABLE}._FIVETRAN_SYNCED ;; group_label: "System Metadata" hidden: yes }

  # =========================================================================
  # 3. MEASURES
  # =========================================================================
  measure: job_line_item_count {
    type: count
    description: "The total recording row volume mapped across execution pipeline runs."
  }
}