view: int_dbt_prod_luminate_global_isrc {

  sql_table_name: intelligence.dbt_prod.luminate_global_isrc ;;

  dimension: report_frequency {
    description: "Luminate ISRC reports are provided daily and weekly. Use this field to filter for the desired report."
    view_label: "Luminate Global ISRC"
    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 ISRC"
    type: date_time
    sql: ${TABLE}.processed_datetime ;;
  }

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

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

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

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

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

  dimension: isrc {
    description: "The ISRC's associated with the track/song."
    view_label: "Luminate Global ISRC"
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: isrc_title {
    description: "The ISRC's title."
    view_label: "Luminate Global ISRC"
    label: "ISRC Title"
    type: string
    sql: ${TABLE}.isrc_title ;;
  }

  dimension: isrc_artist {
    description: "The artist for the track/song."
    view_label: "Luminate Global ISRC"
    label: "ISRC Artist"
    type: string
    sql: ${TABLE}.isrc_artist ;;
  }

  dimension: unified_song_id{
    description: "Luminate's unique ID for a track/song."
    view_label: "Luminate Global ISRC"
    label: "Unified Song ID"
    type: number
    sql: ${TABLE}.unified_song_id ;;
  }

  dimension: title {
    description: "The title of the track/song."
    view_label: "Luminate Global ISRC"
    type: string
    sql: ${TABLE}.title ;;
  }

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

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

  dimension: digital_song_sales_tp {
    description: "The number of digital song sales (i.e song downloads) attributed to the ISRC during the report period (either daily or weekly)."
    view_label: "Luminate Global ISRC"
    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 ISRC"
    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 ISRC during the previous report period (either daily or weekly)."
    view_label: "Luminate Global ISRC"
    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 ISRC year to date."
    view_label: "Luminate Global ISRC"
    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 ISRC since the start of 2022."
    view_label: "Luminate Global ISRC"
    type: number
    sql: ${TABLE}.digital_song_sales_atd_2022 ;;
  }

  dimension: streaming_on_demand_total_tp {
    description: "The number of streams attributed to the ISRC during the report period (either daily or weekly)."
    view_label: "Luminate Global ISRC"
    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 ISRC"
    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 ISRC during the previous report period (either daily or weekly)."
    view_label: "Luminate Global ISRC"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_lp ;;
  }

  dimension: streaming_on_demand_total_ytd {
    description: "The total number of streams attributed to the ISRC year to date."
    view_label: "Luminate Global ISRC"
    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 ISRC since the start of 2022."
    view_label: "Luminate Global ISRC"
    type: number
    sql: ${TABLE}.streaming_on_demand_total_atd_2022 ;;
  }

}