view: dim_artist {
  sql_table_name: facts.prod.DIM_ARTIST ;;

  dimension: artist_id {
    primary_key: yes
    sql: ${TABLE}.ARTISTID ;;
  }

  dimension: artist_name {
    sql: ${TABLE}.ARTISTNAME ;;
  }

  dimension: country_id {
    sql: ${TABLE}.COUNTRYID ;;
  }

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

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

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

  measure: number_of_artists {
    type: count_distinct
    sql: ${TABLE}.ARTISTID ;;
  }
}