view: dt_deleted_releases {
  derived_table: {
    sql: SELECT upc, MAX(TO_DATE(date_deleted)) AS date_deleted
      FROM orchard_app_reporting_v2.art_relations_prod_art_relations.full_deletions
      WHERE action = 'delete'
      GROUP BY 1
       ;;
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.upc ;;
    primary_key: yes
    hidden: yes
  }

  dimension: has_deleted_date {
    type: yesno
    sql: IFF(${TABLE}.upc IS NULL, FALSE, TRUE) ;;
    group_label: "Deleted Date"
  }

  dimension: date_deleted {
    type: date
    sql: ${TABLE}.date_deleted ;;
    group_label: "Deleted Date"
    label: "Deleted Date"
  }
}