label: "Operations"
connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"
include: "/dt_first_approver.view.lkml"

explore: facts_prod_itunes_tickets {
  label: "iTunes Tickets"
  view_label: "iTunes Ticket"
  hidden: no

  join: dt_itunes_ticket_max_date_filter {
    sql_on: ${facts_prod_itunes_tickets.file_date} = ${dt_itunes_ticket_max_date_filter.max_date} ;;
    relationship: many_to_one
    view_label: "File"
  }

  join: facts_prod_itunes_ticket_defect_codes {
    sql_on: ${facts_prod_itunes_tickets.file_date} = ${facts_prod_itunes_ticket_defect_codes.file_date}
      AND ${facts_prod_itunes_tickets.ticketid} = ${facts_prod_itunes_ticket_defect_codes.ticketid} ;;
    relationship: one_to_many
    view_label: "Defect Code"
  }

  join: int_prod_itunes_ticket_severity_mapping {
    type: left_outer
    sql_on: ${int_prod_itunes_ticket_severity_mapping.defect_code} = ${facts_prod_itunes_ticket_defect_codes.defect_code} ;;
    relationship: many_to_one
    view_label: "Defect Code"
  }

  join: facts_prod_itunes_ticket_notes {
    sql_on: ${facts_prod_itunes_tickets.file_date} = ${facts_prod_itunes_ticket_notes.file_date}
      AND ${facts_prod_itunes_tickets.ticketid} = ${facts_prod_itunes_ticket_notes.ticketid} ;;
    relationship: one_to_many
    view_label: "Note"
  }

  join: orch_app_ar_releases {
    sql_on: ${facts_prod_itunes_tickets.orchard_upc} = ${orch_app_ar_releases.upc} ;;
    relationship: many_to_one
    type: inner
    view_label: "Release"
    fields: [
      ingestion_completed_date,
      is_active,
      meta_language,
      preorder_date,
      project_id,
      release_date,
      release_id,
      release_name,
      status,
      sale_start_date,
      upc
    ]
  }
  join: dt_release_approved_by {
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.release_id} = ${dt_release_approved_by.release_id} ;;
  }


  join: dt_itunes_ticket_within_window {
    sql_on: ${orch_app_ar_releases.upc} = ${dt_itunes_ticket_within_window.upc} ;;
    relationship: one_to_one
  }

  join: orch_app_ar_genre {
    sql_on: ${orch_app_ar_releases.release_genre_id} = ${orch_app_ar_genre.genre_id} ;;
    relationship: many_to_one
    view_label: "Release"
  }

  join: orch_app_ar_artist_info {
    sql_on: ${orch_app_ar_artist_info.artist_id} = ${orch_app_ar_releases.artist_id} ;;
    relationship: many_to_one
    view_label: "Artist"
    fields: [artist_id, name]
  }

  join: orch_app_ar_vendor {
    sql_on: ${orch_app_ar_artist_info.vendor_id} = ${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    view_label: "Label"
    fields: [vendor_id, label_name]
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.country} = ${label_country.id} ;;
    fields: [name]
  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
    relationship: many_to_one
    view_label: "Label"
  }

  join: assigned_reviewer {
    from: orch_app_ar_orchadmin_users
    sql_on: ${orch_app_ar_vendor.assigned_reviewer} = ${assigned_reviewer.id} ;;
    relationship: many_to_one
    view_label: "Assigned Reviewer"
  }

  join: product_manager {
    from: int_dbt_prod_product_manager_mapping_union
    sql_on: ${facts_prod_itunes_tickets.orchard_upc} = TRY_TO_NUMERIC(NULLIF(${product_manager.upc},'')) ;;
    relationship: many_to_one
    view_label: "Product Manager"
  }

  join: dt_first_approver {
    from: dt_first_approver
    sql_on: to_varchar(${facts_prod_itunes_tickets.orchard_upc}) = to_varchar(${dt_first_approver.upc}) ;;
    relationship: many_to_one
    view_label: "Release"
    fields: [first_approver]
  }
}