view: dim_owner {
  sql_table_name: facts.prod.DIM_OWNER ;;

  dimension: active_contract {
    sql: ${TABLE}.ACTIVECONTRACT ;;
  }

  dimension_group: date_created {
    type: time
    timeframes: [date,week,month,year]
    sql: ${TABLE}.DATE_CREATED ;;
  }

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

  dimension: owner_abbrivation {
    sql: ${TABLE}.OWNERABBRIVATION ;;
  }

  dimension: ownerid {
    label: "Owner ID"
    primary_key: yes
    sql: ${TABLE}.OWNERID ;;
  }

  dimension: owner_name {
    sql: ${TABLE}.OWNERNAME ;;
  }

  dimension: owner_type {
    sql: ${TABLE}.OWNERTYPE ;;
  }

  measure: number_of_owners {
    type: count_distinct
    sql: ${TABLE}.OWNERID ;;
  }
}