view: dim_imprint {
  sql_table_name: facts.prod.DIM_IMPRINT ;;

  dimension_group: date_created {
    view_label: "Imprint"
    label: "Imprint Created"
    type: time
    timeframes: [date, day_of_week, week, month, year]
    sql: ${TABLE}.DATE_CREATED ;;
  }

  dimension: imprint {
    sql: ${TABLE}.IMPRINT ;;
  }

  dimension: imprint_id {
    primary_key: yes
    sql: ${TABLE}.IMPRINTID ;;
  }

  dimension: label_id {
    hidden:  yes
    sql: ${TABLE}.LABELID ;;
  }

  dimension_group: last_updated {
    type: time
    timeframes: [date, day_of_week, week, month, year]
    sql: ${TABLE}.LAST_UPDATED ;;
  }

  dimension: subaccount_id {
    hidden:  yes
    sql: ${TABLE}.SUBACCOUNTID ;;
  }

  measure: number_of_imprints {
    type: count_distinct
    sql: ${TABLE}.IMPRINTID ;;
  }
}