view: anr_tiktok {
  derived_table: {
    sql: SELECT
          TT.ARTIST,
          TT.CURRENT_FOLLOWERS AS "TikTok Followers",
          TT.WEEKLY_CHANGE_IN_FOLLOWERS AS "TikTok Followers Change",
          TT.CURRENT_WEEKLY_CHANGE_IN_FOLLOWERS AS "TikTok C. Followers Change",
          TT.DAILY_CHANGE_IN_FOLLOWERS AS "TikTok Followers Daily Change",
          ROUND(100 * TT.PERCENTAGE_CHANGE_IN_FOLLOWERS, 2) AS "% TikTok Followers Growth",
          TT.CURRENT_FOLLOWINGS AS "TikTok Followings",
          TT.WEEKLY_CHANGE_IN_FOLLOWINGS AS "TikTok Followings Change",
          TT.CURRENT_WEEKLY_CHANGE_IN_FOLLOWINGS AS "TikTok C. Followings Change",
          TT.DAILY_CHANGE_IN_FOLLOWINGS AS "TikTok Followings Daily Change",
          ROUND(100 * TT.PERCENTAGE_CHANGE_IN_FOLLOWINGS, 2) AS "% TikTok Followings Growth",
          TT.CURRENT_LIKES AS "TikTok Likes",
          TT.WEEKLY_CHANGE_IN_LIKES AS "TikTok Likes Change",
          TT.CURRENT_WEEKLY_CHANGE_IN_LIKES AS "TikTok C. Likes Change",
          TT.DAILY_CHANGE_IN_LIKES AS "TikTok Likes Daily Change",
          ROUND(100 * TT.PERCENTAGE_CHANGE_IN_LIKES, 2) AS "% TikTok Likes Growth",
          TT.LAST_PROCESSING_DATE
          FROM TABLE({% parameter stats_table_name %}) TT
          WHERE
              TT.LAST_PROCESSING_DATE >= DATEADD(
                'day',
                -29,
                CURRENT_DATE()
              )
              AND TT.ARTIST IN (SELECT ARTIST FROM TABLE({% parameter artist_table_name %}));;
  }

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

  dimension: tiktok_followers {
    type: number
    sql:  ${TABLE}."TikTok Followers";;
  }

  dimension: tiktok_followers_change {
    type: number
    sql: ${TABLE}."TikTok Followers Change";;
  }

  dimension: tiktok_c_followers_change {
    type: number
    sql: ${TABLE}."TikTok C. Followers Change";;
  }

  dimension: tiktok_followers_daily_change {
    type: number
    sql: ${TABLE}."TikTok Followers Daily Change";;
  }

  dimension: tiktok_followers_growth {
    type:  number
    sql:  ${TABLE}."% TikTok Followers Growth";;
  }

  dimension: tiktok_followings {
    type: number
    sql:  ${TABLE}."TikTok Followings";;
  }

  dimension: tiktok_followings_change {
    type: number
    sql: ${TABLE}."TikTok Followings Change";;
  }

  dimension: tiktok_c_followings_change {
    type: number
    sql: ${TABLE}."TikTok C. Followings Change";;
  }

  dimension: tiktok_followings_daily_change {
    type: number
    sql: ${TABLE}."TikTok Followings Daily Change";;
  }

  dimension: tiktok_followings_growth {
    type:  number
    sql:  ${TABLE}."% TikTok Followings Growth";;
  }

  dimension: tiktok_likes {
    type: number
    sql:  ${TABLE}."TikTok Likes";;
  }

  dimension: tiktok_likes_change {
    type: number
    sql: ${TABLE}."TikTok Likes Change";;
  }

  dimension: tiktok_c_likes_change {
    type: number
    sql: ${TABLE}."TikTok C. Likes Change";;
  }

  dimension: tiktok_likes_daily_change {
    type: number
    sql: ${TABLE}."TikTok Likes Daily Change";;
  }

  dimension: tiktok_likes_growth {
    type:  number
    sql:  ${TABLE}."% TikTok Likes Growth";;
  }

  dimension: last_processing_date {
    type: date
    sql: ${TABLE}.LAST_PROCESSING_DATE;;
  }

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

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

view: anr_tiktok_followers {
  derived_table: {
    sql: SELECT
          TT.ARTIST,
          TT.CURRENT_FOLLOWERS AS "TikTok Followers"
          FROM TABLE({% parameter stats_table_name %}) TT
          WHERE
              TT.LAST_PROCESSING_DATE >= DATEADD(
                'day',
                -29,
                CURRENT_DATE()
              )
              AND TT.ARTIST IN (SELECT ARTIST FROM TABLE({% parameter artist_table_name %}));;
  }

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

  dimension: tiktok_followers {
    type: number
    sql:  ${TABLE}."TikTok Followers";;
  }

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

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

view: anr_tiktok_followings {
  derived_table: {
    sql: SELECT
          TT.ARTIST,
          TT.CURRENT_FOLLOWINGS AS "TikTok Followings"
          FROM TABLE({% parameter stats_table_name %}) TT
          WHERE
              TT.LAST_PROCESSING_DATE >= DATEADD(
                'day',
                -29,
                CURRENT_DATE()
              )
              AND TT.ARTIST IN (SELECT ARTIST FROM TABLE({% parameter artist_table_name %}));;
  }

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

  dimension: tiktok_followings {
    type: number
    sql:  ${TABLE}."TikTok Followings";;
  }

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

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

view: anr_tiktok_likes {
  derived_table: {
    sql: SELECT
          TT.ARTIST,
          TT.CURRENT_LIKES AS "TikTok Likes"
          FROM TABLE({% parameter stats_table_name %}) TT
          WHERE
              TT.LAST_PROCESSING_DATE >= DATEADD(
                'day',
                -29,
                CURRENT_DATE()
              )
              AND TT.ARTIST IN (SELECT ARTIST FROM TABLE({% parameter artist_table_name %}));;
  }

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

  dimension: tiktok_likes {
    type: number
    sql:  ${TABLE}."TikTok Likes";;
  }

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

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