view: cm_raw_data_cm_artist {
  sql_table_name: chartmetric.raw_data.cm_artist ;;

  dimension: id {
    type: number
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.id ;;
  }

  dimension: name {
    label: "Artist Name"
    type: string
    hidden: no
    sql: ${TABLE}.name ;;
    view_label: "Artist"
  }


  dimension: image_url {
    type: string
    hidden: yes
    sql: ${TABLE}.image_url ;;
  }

  dimension: cover_url {
    type: string
    hidden: yes
    sql: ${TABLE}.cover_url ;;
  }

  dimension: code2 {
    label: "Artist Country"
    type: string
    hidden: yes
    sql: ${TABLE}.code2 ;;
    view_label: "Artist"
  }

  dimension: gender {
    label: "Artist Gender"
    type: number
    hidden: yes
    sql: ${TABLE}.gender;;
    view_label: "Artist"
  }

  dimension: description {
    label: "Artist Description"
    type: string
    hidden: yes
    sql: ${TABLE}.description ;;
    view_label: "Artist"
  }

  dimension_group: created_at {
    type: time
    hidden: yes
    sql: ${TABLE}.created_at ;;
    timeframes: [
      date,
      day_of_week,
      day_of_week_index,
      day_of_month,
      week,
      week_of_year,
      month,
      month_name,
      month_num,
      quarter,
      quarter_of_year,
      year
    ]
  }

  dimension: hometown_city {
    label: "Hometown City"
    type: number
    hidden: yes
    sql: ${TABLE}.hometown_city ;;
    view_label: "Artist"
  }

  dimension: current_city {
    label: "Current City"
    type: number
    hidden: yes
    sql: ${TABLE}.current_city ;;
    view_label: "Artist"
  }


  dimension: date_of_birth {
    type: date
    hidden: no
    sql: ${TABLE}.date_of_birth ;;
  }

   dimension: date_of_death {
    type: date
    hidden: no
    sql: ${TABLE}.date_of_death ;;
  }

  dimension_group: modified_at {
    type: time
    hidden: yes
    sql: ${TABLE}.modified_at ;;
    timeframes: [
      date,
      day_of_week,
      day_of_week_index,
      day_of_month,
      week,
      week_of_year,
      month,
      month_name,
      month_num,
      quarter,
      quarter_of_year,
      year
    ]
  }





}