view: facts_prod_cm_url_backfill {
  sql_table_name: facts.prod.cm_url_backfill ;;

  dimension: url {
    type: string
    sql: ${TABLE}.url ;;
    view_label: "URL"
  }

  dimension: target_id {
    type: number
    sql: ${TABLE}.target_id ;;
    view_label: "Target Id"
  }

  dimension: type {
    type: number
    sql: ${TABLE}.type ;;
    view_label: "Type"
  }

  dimension: modified_at {
    type: date
    sql: ${TABLE}.modified_at ;;
    view_label: "Modified At"
  }

  dimension: ingested_at {
    type: date
    sql: ${TABLE}.ingested_at ;;
    view_label: "Ingested At"
  }

  dimension: ingestion_started_at {
    type: date
    sql: ${TABLE}.ingestion_started_at ;;
    view_label: "Ingestion Started At"
  }

  measure: time_taken {
    type:  number
    sql:  ROUND(AVG(TIMEDIFF('second', ${TABLE}.ingestion_started_at, ${TABLE}.ingested_at))/60, 2) ;;
    view_label: "Time taken in minutes"
  }
}