view: int_dbt_prod_chartmetric_social_stats {
  sql_table_name: INTELLIGENCE.DBT_PROD.CHARTMETRIC_SOCIAL_STATS ;;

  dimension: artist_id {
    view_label: "Artist"
    label: "Artist ID"
    type: number
    sql: ${TABLE}.artistid ;;
    hidden: yes
  }

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

  dimension: chartmetric_id {
    label: "Chartmetric ID"
    type: number
    sql: ${TABLE}.charmetric_id ;;
  }

  dimension: instagram_followers {
    view_label: "Chartmetric Social Stats"
    label: "Instagram Followers"
    type: number
    sql: ${TABLE}.instagram_followers ;;
  }

  dimension: facebook_followers {
    view_label: "Chartmetric Social Stats"
    label: "Facebook Followers"
    type: number
    sql: ${TABLE}.facebook_followers ;;
  }

  dimension: twitter_followers {
    view_label: "Chartmetric Social Stats"
    label: "Twitter Followers"
    type: number
    sql: ${TABLE}.twitter_followers ;;
  }

  dimension: tiktok_followers {
    view_label: "Chartmetric Social Stats"
    label: "TikTok Followers"
    type: number
    sql: ${TABLE}.tiktok_followers ;;
  }

  dimension: spotify_followers {
    view_label: "Chartmetric Social Stats"
    label: "Spotify Followers"
    type: number
    sql: ${TABLE}.spotify_followers ;;
    hidden: yes
  }

  dimension: deezer_followers {
    view_label: "Chartmetric Social Stats"
    label: "Deezer Followers"
    type: number
    sql: ${TABLE}.deezer_followers ;;
  }

  dimension: youtube_subscriber {
    view_label: "Chartmetric Social Stats"
    label: "YouTube Subscribers"
    type: number
    sql: ${TABLE}.youtube_subscriber ;;
  }


  }