view: facts_prod_chartmetric_socials {
  sql_table_name: facts.prod.chartmetric_socials_log ;;

  dimension: timestp {
    type: date
    sql: ${TABLE}.timestp ;;
    view_label: "Timestp"
  }

  dimension: platform_name {
    type: string
    sql: ${TABLE}.platform_name ;;
    view_label: "Platform Name"
  }

  dimension: unique_key {
    type: string
    sql: ${TABLE}.unique_key ;;
    view_label: "Unique Key"
  }

  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"
  }
}