view: int_dbt_prod_luminate_global_song {

  sql_table_name: intelligence.dbt_prod.luminate_global_song ;;

  dimension: report_frequency {
    description: "Luminate song reports are provided daily and weekly. Use this field to filter for the desired report."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.report_frequency ;;
  }

  dimension: processed_datetime {
    description: "The date an time that the data was ingested into snowflake."
    view_label: "Luminate Global Song"
    type: date_time
    sql: ${TABLE}.processed_datetime ;;
  }

  dimension: country_code {
    description: "The country code that activity occured in."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.country_code ;;
  }

  dimension: country {
    description: "The country that activity occured in."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.country ;;
  }

  dimension: week_id {
    description: "The corresponding week ID that activity occured in."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.week_id ;;
  }

  dimension: download_date {
    description: ""
    view_label: "Luminate Global Song"
    type: date
    sql: ${TABLE}.download_date ;;
  }

  dimension: rank {
    description: "The artists' rank for a particular report and country."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.rank ;;
  }

  dimension: unified_artist_id {
    description: "Luminate's unique ID for an artist."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.unified_artist_id ;;
  }

  dimension: unified_song_id {
    description: "Luminate's unique ID for a song. A song can be made up of multiple ISRCs."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.unified_song_id ;;
  }

  dimension: title {
    description: "The song title."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.title ;;
  }

  dimension: artist {
    description: "The artist's name."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.artist ;;
  }

  dimension: top_isrc {
    description: "The ISRC associated with the song that is attributed with the most activity."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.top_isrc ;;
  }

  dimension: digital_song_sales_tp {
    description: "The number of digital song sales (i.e song downloads) attributed to the song during the report period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.digital_song_sales_tp ;;
  }

  dimension: digital_song_sales_percent_change_lp {
    description: "The percentage change of digital song sales (i.e song downloads) for this period compared to last period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.digital_song_sales_percent_change_lp ;;
  }

  dimension: digital_song_sales_lp {
    description: "The number of digital song sales (i.e song downloads) attributed to the song during the previous report period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.digital_song_sales_lp ;;
  }

  dimension: digital_song_sales_ytd {
    description: "The total number of digital song sales (i.e song downloads) attributed to the song year to date."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.digital_song_sales_ytd ;;
  }

  dimension: digital_song_sales_atd_2022 {
    description: "The total number of digital song sales (i.e song downloads) attributed to the song since the start of 2022."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.digital_song_sales_atd_2022 ;;
  }

  dimension: streaming_on_demand_total_tp {
    description: "The number of streams attributed to the song during the report period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_tp ;;
  }

  dimension: streaming_on_demand_total_percent_change_lp {
    description: "The percentage change of streams for this period compared to last period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: string
    sql: ${TABLE}.streaming_on_demand_total_percent_change_lp ;;
  }

  dimension: streaming_on_demand_total_lp {
    description: "The number of streams attributed to the song during the previous report period (either daily or weekly)."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_lp ;;
  }

  dimension: streaming_on_demand_total_ytd {
    description: "The total number of streams attributed to the song year to date."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_ytd ;;
  }

  dimension: streaming_on_demand_total_atd_2022 {
    description: "The total number of streams attributed to the song since the start of 2022."
    view_label: "Luminate Global Song"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_atd_2022 ;;
  }

}