view: audits_flags {
  sql_table_name: INTELLIGENCE.QA_YOUTUBE_AUDIT_YOUTUBE_AUDIT.AUDITS_FLAGS ;;

  dimension: id {
    label: "Flag ID"
    type: string
    sql: ${TABLE}.id ;;
  }

  dimension: audit {
    label: "Audit"
    type: string
    sql: ${TABLE}.audit ;;
    hidden: yes
  }

  dimension: flag {
    label: "Flag"
    type: string
    sql: ${TABLE}.flag ;;
  }

  dimension_group: date_created_utc {
    label: "Flag Created"
    type: time
    timeframes: [
      day_of_week,
      date,
      week,
      month,
      quarter,
      year,
      time
    ]
    sql: ${TABLE}.date_created_utc ;;
  }

  dimension_group: date_resolved_utc {
    label: "Flag Resolved"
    type: time
    timeframes: [
      day_of_week,
      date,
      week,
      month,
      quarter,
      year,
      time
    ]
    sql: ${TABLE}.date_resolved_utc ;;
  }

  dimension: resolution {
    label: "Resolution"
    type: string
    sql: ${TABLE}.resolution ;;
  }

  dimension: resolved_by {
    label: "Resolved By"
    type: string
    sql: case when ${TABLE}.resolved_by is not null then ${users.name} end ;;
  }

  dimension: upc {
    label: "UPC"
    type: string
    sql: ${TABLE}.upc ;;
  }

  dimension: isrc {
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: created_by {
    label: "Flag Created By"
    type: string
    sql: case when ${TABLE}.flag is not null then ${users.name} end ;;
  }

  dimension: details {
    label: "Flag Details"
    type: string
    sql: ${TABLE}.details ;;
  }

  dimension: asset_id {
    label: "Asset ID"
    type: string
    sql: ${TABLE}.asset_id ;;
  }

  dimension: video_id {
    label: "Video ID"
    type: string
    sql: ${TABLE}.video_id ;;
  }

  dimension: row_idx {
    label: "Row Index"
    type: string
    sql: ${TABLE}.row_indx ;;
    hidden: yes
  }

  dimension: resolution_subtype {
    label: "Resolution Subtype"
    type: string
    sql: ${TABLE}.resolution_subtype ;;
  }

}