view: int_dbt_prod_spotify_3rd_party_playlist_spt_last_week {
  sql_table_name: intelligence.dbt_prod.spotify_3rd_party_playlist_spt_last_week ;;

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

  dimension:playlist_type {
    type: string
    view_label: "Playlist"
    label: "Playlist Type"
    hidden: no
    sql: ${TABLE}.playlist_type ;;
  }

  dimension:playlist_author {
    type: string
    view_label: "Playlist"
    label: "Playlist Author"
    hidden: no
    sql: ${TABLE}.playlist_author ;;
  }

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

  dimension:playlist_uri {
    type: string
    view_label: "Playlist"
    label: "Playlist URI"
    hidden: no
    sql: ${TABLE}.playlist_uri ;;
  }

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

  dimension: number_of_tracks {
    type: number
    view_label: "Metrics"
    label: "Number of Tracks"
    hidden: no
    sql: ${TABLE}.streams ;;
  }

  dimension: streams_per_track {
    type: number
    view_label: "Metrics"
    label: "Streams Per Track"
    hidden: no
    sql: ${TABLE}.streams_per_track ;;
    value_format: "0"
  }



  }