view: facts_prod_streams_by_country_feed_distributor_rollup_dbt {
  derived_table: {
    sql:
      SELECT
        ROW_NUMBER() OVER (ORDER BY track_id, country_code, feed_id, product_id, isrc, distributor, label_id) AS row_number,
        track_id,
        country_code,
        feed_id,
        store_id,
        product_id,
        isrc,
        distributor,
        label_id,
        streams_1_day,
        streams_1_day_prev,
        streams_7_days,
        streams_7_days_prev,
        streams_28_days,
        streams_28_days_prev,
        streams_183_days,
        streams_183_days_prev,
        streams_365_days_prev,
        streams_all_time
      FROM (
        SELECT
          track_id,
          country_code,
          feed_id,
          store_id,
          product_id,
          isrc,
          distributor,
          label_id,
          SUM(streams_1_day) AS streams_1_day,
          SUM(streams_1_day_prev) AS streams_1_day_prev,
          SUM(streams_7_days) AS streams_7_days,
          SUM(streams_7_days_prev) AS streams_7_days_prev,
          SUM(streams_28_days) AS streams_28_days,
          SUM(streams_28_days_prev) AS streams_28_days_prev,
          SUM(streams_183_days) AS streams_183_days,
          SUM(streams_183_days_prev) AS streams_183_days_prev,
          SUM(streams_365_days_prev) AS streams_365_days_prev,
          SUM(streams_all_time) AS streams_all_time
        FROM FACTS.PROD.V_STREAMS_BY_TRACK_COUNTRY_FEED_DISTRIBUTOR_ROLLUP
        GROUP BY
          track_id,
          country_code,
          feed_id,
          store_id,
          product_id,
          isrc,
          distributor,
          label_id
      ) AS aggregated_data ;;
  }
  dimension: row_number {
    type: number
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.row_number ;;
  }

  dimension: track_id {
    type: number
    sql: ${TABLE}.track_id ;;
  }

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

  dimension: feed_id {
    type: number
    view_label: "Feed"
    label: "Feed ID"
    sql: ${TABLE}.feed_id ;;
  }

  dimension: distributor {
    type: string
    view_label: "Distributor"
    label: "Distributor"
    sql: ${TABLE}.distributor ;;
  }

  dimension: store_id {
    type: number
    view_label: "Store"
    label: "Store ID"
    sql: ${TABLE}.store_id ;;
  }

  dimension: product_id {
    type: number
    view_label: "Product"
    label: "Product ID"
    sql: ${TABLE}.product_id ;;
  }

  dimension: isrc {
    type: string
    view_label: "Product"
    label: "ISRC"
    sql: ${TABLE}.isrc ;;
  }

  dimension: label_id {
    type: string
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.label_id ;;
  }

  measure: streams_1day {
    type: sum
    view_label: "Streams"
    label: "1 Day Streams"
    sql: ${TABLE}.streams_1_day ;;
  }

  measure: streams_1day_prev {
    type: sum
    view_label: "Streams"
    label: "1 Day Streams (Previous)"
    sql: ${TABLE}.streams_1_day_prev ;;
  }

  measure: streams_7day {
    type: sum
    view_label: "Streams"
    label: "7 Days Streams"
    sql: ${TABLE}.streams_7_days ;;
  }

  measure: streams_7days_prev {
    type: sum
    view_label: "Streams"
    label: "7 Days Streams (Previous)"
    sql: ${TABLE}.streams_7_days_prev ;;
  }

  measure: streams_28days {
    type: sum
    view_label: "Streams"
    label: "28 Days Streams"
    sql: ${TABLE}.streams_28_days ;;
  }

  measure: streams_28days_prev {
    type: sum
    view_label: "Streams"
    label: "28 Days Streams (Previous)"
    sql: ${TABLE}.streams_28_days_prev ;;
  }

  measure: streams_183days {
    type: sum
    view_label: "Streams"
    label: "183 Days Streams"
    sql: ${TABLE}.streams_183_days ;;
  }

  measure: streams_183days_prev {
    type: sum
    view_label: "Streams"
    label: "183 Days Streams (Previous)"
    sql: ${TABLE}.streams_183_days_prev ;;
  }

  measure: streams_365days {
    type: sum
    view_label: "Streams"
    label: "365 Days Streams (Previous)"
    sql: ${TABLE}.streams_365_days_prev ;;
  }

  measure: streams_all_time {
    type: sum
    view_label: "Streams"
    label: "All Time Streams"
    sql: ${TABLE}.streams_all_time ;;
  }
}