view: int_dbt_prod_weekly_trending_tracks_deezer {
  sql_table_name: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_DEEZER ;;

  dimension: country_code {
    view_label: "Transaction Country"
    type: string
    hidden: yes
    sql: ${TABLE}.country_code;;
  }

  dimension: labelid {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.label_id;;
  }


  dimension: isrc {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.ISRC;;
  }

  dimension: upc {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.upc;;
  }

  dimension: track_name {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.track_name;;
  }

  dimension: artist_name {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.artist_name;;
  }


  dimension: current_week_streams {
    view_label: "Metrics"
    label: "Weekly Streams"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_streams;;
  }

  dimension: average_streams {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.avg_streams;;
    value_format: "#,##0"
  }

  dimension: percent_above_average {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg;;
    value_format: "0.00\%"
  }

  dimension: spike_score {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score;;
    value_format: "0.##"
  }



}