view: int_dbt_prod_orch_spotify_top_200_chart_appearances {
  sql_table_name:intelligence.dbt_prod.orch_spotify_top_200_chart_appearances;;


  dimension: Chart_country{
    label:"Chart Country"
    type: string
    sql:${TABLE}.Chart_country;;
  }
  dimension: Artist_name{
    label:"Artist name"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension: Spotify_artist_id{
    label:"Spotify artist id"
    type: string
    sql:${TABLE}.Spotify_artist_id;;
  }
  measure: Spotify_followeres{
    label:"Spotify followeres"
    type: sum
    sql:${TABLE}.Spotify_followeres;;
  }
  measure: Spotify_popularity{
    label:"Spotify popularity"
    type: sum
    sql:${TABLE}.Spotify_popularity;;
  }
  measure: Spotify_monthly_listeners{
    label:"Spotify monthly listeners"
    type: sum
    sql:${TABLE}.Spotify_monthly_listeners;;
  }
  dimension_group: Min_release_date{
    label:"Min_release_date"
    type: time
    sql:${TABLE}.Min_release_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: Fixed_release_date{
    label:"Fixed_release_date"
    type: time
    sql:${TABLE}.Fixed_release_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: Isrc{
    label:"Isrc"
    type: string
    sql:${TABLE}.Isrc;;
  }
  dimension: Current_rank{
    label:"Current_rank"
    type: number
    sql:${TABLE}.Current_rank;;
  }
  dimension: Peak_rank{
    label:"Peak_rank"
    type: number
    sql:${TABLE}.Peak_rank;;
  }
  dimension: Min_chart_date{
    label:"Min_chart_date"
    type: date
    sql:${TABLE}.Min_chart_date;;
  }
  dimension: Max_chart_date{
    label:"Max_chart_date"
    type: date
    sql:${TABLE}.Max_chart_date;;
  }
  dimension: Days_to_chart{
    label:"Days_to_chart"
    type: number
    sql:${TABLE}.Days_to_chart;;
  }
  dimension: Hit{
    label:"Hit"
    type: number
    sql:${TABLE}.Hit;;
  }
  dimension: Previous_hit{
    label:"Previous_hit"
    type: number
    sql:${TABLE}.Previous_hit;;
  }
  dimension: Previous_hit_country{
    label:"Previous_hit_country"
    type: string
    sql:${TABLE}.Previous_hit_country;;
  }
  dimension: Days_since_last_hit{
    label:"Days_since_last_hit"
    type: number
    sql:${TABLE}.Days_since_last_hit;;
  }
  dimension: Latest_hit_date{
    label:"Latest_hit_date"
    type: date
    sql:${TABLE}.Latest_hit_date;;
  }
  dimension: Acousticness{
    label:"Acousticness"
    type: number
    sql:${TABLE}.Acousticness;;
  }
  dimension: Danceability{
    label:"Danceability"
    type: number
    sql:${TABLE}.Danceability;;
  }
  dimension: Duration_ms{
    label:"Duration_ms"
    type: number
    sql:${TABLE}.Duration_ms;;
  }
  dimension: Energy{
    label:"Energy"
    type: number
    sql:${TABLE}.Energy;;
  }
  dimension: Instrumentalness{
    label:"Instrumentalness"
    type: number
    sql:${TABLE}.Instrumentalness;;
  }
  dimension: Key{
    label:"Key"
    type: number
    sql:${TABLE}.Key;;
  }
  dimension: Liveness{
    label:"Liveness"
    type: number
    sql:${TABLE}.Liveness;;
  }
  dimension: Loudness{
    label:"Loudness"
    type: number
    sql:${TABLE}.Loudness;;
  }
  dimension: Mode{
    label:"Mode"
    type: number
    sql:${TABLE}.Mode;;
  }
  dimension: Speechiness{
    label:"Speechiness"
    type: number
    sql:${TABLE}.Speechiness;;
  }
  dimension: Tempo{
    label:"Tempo"
    type: number
    sql:${TABLE}.Tempo;;
  }
  dimension: Time_signature{
    label:"Time_signature"
    type: number
    sql:${TABLE}.Time_signature;;
  }
  dimension: Valence{
    label:"Valence"
    type: number
    sql:${TABLE}.Valence;;
  }

}