view: dim_genre {
  sql_table_name: facts.prod.DIM_GENRE ;;

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

  dimension: genreid {
    label: "Genre ID"
    primary_key: yes
    sql: ${TABLE}.GENREID ;;
  }

  dimension: genre_name {
    sql: ${TABLE}.GENRENAME ;;
  }

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

  measure: number_of_genres {
    type: count_distinct
    sql: ${TABLE}.GENREID ;;
  }
}