view: cm_raw_data_itunes {
  sql_table_name: chartmetric.raw_data.itunes ;;

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

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

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

  dimension: track_name {
    label: "Track Name"
    type: string
    hidden: yes
    sql: ${TABLE}.track_name ;;
    view_label: "iTunes/Apple"
  }

  dimension: artist_name {
    label: "Artist Name"
    type: string
    hidden: yes
    sql: ${TABLE}.artist_name ;;
    view_label: "iTunes/Apple"
  }

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

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

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

  dimension: track_genre {
    label: "Genre"
    type: string
    hidden: yes
    sql: ${TABLE}.track_genre ;;
    view_label: "iTunes/Apple"
  }

  dimension: isrc {
    label: "iTunes ISRC"
    type: string
    hidden: yes
    sql: ${TABLE}.isrc ;;
    view_label: "iTunes/Apple"
  }

  dimension: storefront {
    label: "iTunes Storefront"
    type: string
    hidden: no
    sql: ${TABLE}.storefront ;;
    view_label: "iTunes/Apple"
  }

  dimension: composer_name {
    label: "Track Composer Name"
    type: string
    hidden: no
    sql: ${TABLE}.composer_name ;;
    view_label: "iTunes/Apple"
  }

  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
    ]
    view_label: "iTunes/Apple"
  }

  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
    ]
  }
}