view: orch_app_ar_product_video_approval {
derived_table: {
  sql: select pva.*,
  concat(ou.f_name, ' ', ou.l_name) as rejection_by_name
  from  ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.PRODUCT_VIDEO_APPROVAL pva
  left join orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users ou
  on SPLIT_PART(pva.rejection_by , 'oa:', 2) = ou.id
  ;;
}

  dimension: release_id {
    label: "Release ID"
    type: string
    sql: ${TABLE}.release_id ;;
    hidden: yes
  }


  dimension: rejection_reason {
    label: "Rejection Reason"
    type: string
    sql: ${TABLE}.rejection_reason ;;
  }

  dimension: rejection_by_name {
    label: "Rejection By"
    type: string
    sql: ${TABLE}.rejection_by_name ;;
  }

 dimension_group: rejection_at {
  label: "Rejection"
  sql: ${TABLE}.rejection_at ;;
  type: time
  timeframes: [year,
    quarter,
    month,
    week,
    date,
    day_of_year,
    day_of_week,
    week_of_year,
    month_name,
    month_num,
    raw
  ]
}

}