view: anr_soundcloud {
  derived_table: {
    sql: SELECT
          SC.ARTIST,
    SC.CURRENT_FOLLOWERS_COUNT AS "SC Followers",
          SC.WEEKLY_CHANGE_IN_FOLLOWERS_COUNT AS "SC Weekly Followers",
          SC.CURRENT_WEEKLY_CHANGE_IN_FOLLOWERS_COUNT AS "SC C. Weekly Followers",
          SC.DAILY_CHANGE_IN_FOLLOWERS_COUNT AS "SC Daily Followers",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_FOLLOWERS_COUNT, 2) AS "% SC Followers Growth",
          ROUND(100 * SC.ACCELERATION_FOLLOWERS_COUNT, 2) AS "% SC F. Acceleration",
    SC.CURRENT_TRACKS_COUNT AS "SC Tracks",
          SC.WEEKLY_CHANGE_IN_TRACKS_COUNT AS "SC Weekly Tracks",
    SC.CURRENT_PLAYS_COUNT AS "SC Plays",
    SC.WEEKLY_CHANGE_IN_PLAYS_COUNT AS "SC Weekly Plays",
    SC.CURRENT_WEEKLY_CHANGE_IN_PLAYS_COUNT AS "SC C. Weekly Plays",
    SC.DAILY_CHANGE_IN_PLAYS_COUNT AS "SC Daily Plays",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_PLAYS_COUNT, 2) AS "% SC Plays Growth",
          ROUND(100 * SC.ACCELERATION_PLAYS_COUNT, 2) AS "% SC P. Acceleration",
    SC.CURRENT_LIKES_COUNT AS "SC Likes",
    SC.WEEKLY_CHANGE_IN_LIKES_COUNT AS "SC Weekly Likes",
    SC.CURRENT_WEEKLY_CHANGE_IN_LIKES_COUNT AS "SC C. Weekly Likes",
    SC.DAILY_CHANGE_IN_LIKES_COUNT AS "SC Daily Likes",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_LIKES_COUNT, 2) AS "% SC Likes Growth",
          ROUND(100 * SC.ACCELERATION_LIKES_COUNT, 2) AS "% SC L. Acceleration",
   SC.CURRENT_REPOSTS_COUNT AS "SC Reposts",
   SC.WEEKLY_CHANGE_IN_REPOSTS_COUNT AS "SC Weekly Reposts",
          ROUND(100 * SC.PERCENTAGE_CHANGE_IN_REPOSTS_COUNT, 2) AS "% SC Reposts Growth",
    (100 * SC.PLAYS_ENGAGEMENT) AS "SC Engagement",
    SC.THE_LATEST_RELEASE AS "SC Release",
    SC.LAST_PROCESSING_DATE AS "SC Last Processing Date"
      FROM TABLE({% parameter stats_table_name %}) SC
      WHERE
        SC.LAST_PROCESSING_DATE >= DATEADD(
          'day',
          -29,
          CURRENT_DATE()
        )
        AND SC.ARTIST IN (SELECT ARTIST FROM TABLE({% parameter artist_table_name %}));;
  }

  dimension: artist {
    type: string
    sql: ${TABLE}.ARTIST;;
  }

  dimension: soundloud_followers {
    type: number
    sql:  ${TABLE}."SC Followers";;
  }

  dimension: soundcloud_followers_change {
    type: number
    sql: ${TABLE}."SC Weekly Followers";;
  }

  dimension: soundcloud_c_followers_change {
    type: number
    sql: ${TABLE}."SC C. Weekly Followers";;
  }

  dimension: soundcloud_followers_daily_change {
    type: number
    sql: ${TABLE}."SC Daily Followers";;
  }

  dimension: soundcloud_followers_growth {
    type: number
    sql: ${TABLE}."% SC Followers Growth";;
  }

  dimension: soundcloud_followers_acceleration {
    type: number
    sql: ${TABLE}."% SC F. Acceleration";;
  }

  dimension: soundloud_tracks {
    type: number
    sql:  ${TABLE}."SC Tracks";;
  }

  dimension: soundcloud_tracks_change {
    type: number
    sql: ${TABLE}."SC Weekly Tracks";;
  }

  dimension: soundcloud_plays {
    type: number
    sql: ${TABLE}."SC Plays";;
  }

  dimension: soundcloud_plays_change {
    type: number
    sql: ${TABLE}."SC Weekly Plays";;
  }

  dimension: soundcloud_c_plays_change {
    type: number
    sql: ${TABLE}."SC C. Weekly Plays";;
  }

  dimension: soundcloud_plays_daily_change {
    type: number
    sql: ${TABLE}."SC Daily Plays";;
  }

  dimension: soundcloud_plays_growth {
    type: number
    sql: ${TABLE}."% SC Plays Growth";;
  }

  dimension: soundcloud_plays_acceleration {
    type: number
    sql: ${TABLE}."% SC P. Acceleration";;
  }

  dimension: soundcloud_likes {
    type: number
    sql: ${TABLE}."SC Likes";;
  }

  dimension: soundcloud_likes_change {
    type: number
    sql: ${TABLE}."SC Weekly Likes";;
  }

  dimension: soundcloud_c_likes_change {
    type: number
    sql: ${TABLE}."SC C. Weekly Likes";;
  }

  dimension: soundcloud_likes_daily_change {
    type: number
    sql: ${TABLE}."SC Daily Likes";;
  }

  dimension: soundcloud_likes_growth {
    type: number
    sql: ${TABLE}."% SC Likes Growth";;
  }

  dimension: soundcloud_likes_acceleration {
    type: number
    sql: ${TABLE}."% SC L. Acceleration";;
  }

  dimension: soundcloud_reposts {
    type: number
    sql: ${TABLE}."SC Reposts";;
  }

  dimension: soundcloud_reposts_change {
    type: number
    sql: ${TABLE}."SC Weekly Reposts";;
  }

  dimension: soundcloud_reposts_growth {
    type: number
    sql: ${TABLE}."% SC Reposts Growth";;
  }

  dimension: soundloud_engagement {
    type: number
    sql:  ${TABLE}."SC Engagement";;
  }

  dimension: soundloud_release {
    type: date
    sql:  ${TABLE}."SC Release";;
  }

  dimension: soundloud_processing_date {
    type: date
    sql:  ${TABLE}."SC Last Processing Date";;
  }

  parameter: stats_table_name {
    type: string
    view_label: "Table Name"
    default_value: "FACTS.PROD.SOUNDCLOUD_STATISTICS"
  }

  parameter: artist_table_name {
    type: string
    view_label: "Artist Table Name"
    default_value: "FACTS.PROD.ARTIST_TO_TRACK"
  }
}

view: anr_soundcloud_weekly {
  derived_table: {
    sql: select distinct SC.ARTIST, SC.CURRENT_WEEKLY_CHANGE_IN_PLAYS_COUNT AS WEEKLY,
          SC.WEEKLY_CHANGE_IN_PLAYS_COUNT AS LAST_WEEKLY, ROUND(100 * SC.PERCENTAGE_CHANGE_IN_PLAYS_COUNT, 2) AS PERCENTAGE_CHANGE,
          SC.LAST_PROCESSING_DATE, SC.LAST_PROCESSING_DATE
          from TABLE({% parameter stats_table_name %}) SC, TABLE({% parameter staging_table_name %}) S;;
  }

  dimension: artist {
    type: string
    sql: ${TABLE}.ARTIST;;
  }

  dimension: soundcloud_weekly_change_in_plays {
    type: number
    sql:  ${TABLE}.WEEKLY;;
  }

  dimension: soundcloud_last_weekly_change_in_plays {
    type: number
    sql: ${TABLE}.LAST_WEEKLY;;
  }

  dimension: soundcloud_percentage_change_in_plays {
    type: number
    sql: ${TABLE}.PERCENTAGE_CHANGE;;
  }

  parameter: stats_table_name {
    type: string
    view_label: "Table Name"
    default_value: "FACTS.PROD.SOUNDCLOUD_STATISTICS"
  }

  parameter: staging_table_name {
    type: string
    view_label: "Staging Raw Table Name"
    default_value: "FACTS.PROD.STAGING_RAW_SOUNDCLOUD_STATISTICS"
  }
}