view: int_dbt_prod_release_compare_model_spotify_store {

  sql_table_name:"INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_SPOTIFY_STORE";;


  dimension: Upc{
    label:"UPC"
    type: string
    sql:${TABLE}.Upc;;
  }
  dimension_group: Sale_start_date{
    label:"Sale Start Date"
    type: time
    sql:${TABLE}.Sale_start_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: Days_since_release{
    label:"Days Since Release"
    type: number
    sql:${TABLE}.Days_since_release;;
  }
  dimension: Subaccount_id{
    label:"Subaccount ID"
    type: string
    sql:${TABLE}.Subaccount_id;;
  }
  dimension: Subaccount_name{
    label:"Subaccount Name"
    type: string
    sql:${TABLE}.Subaccount_name;;
  }
  dimension: Artist_id{
    label:"Artist ID"
    type: string
    sql:${TABLE}.Artist_id;;
  }
  dimension: Artist_name{
    label:"Artist Name"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension_group: Activity_date{
    label:"Activity Date"
    type: time
    sql:${TABLE}.Activity_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: User_id{
    label:"User ID"
    type: string
    sql:${TABLE}.User_id;;
  }
  dimension: Source_uri{
    label:"Source URI"
    type: string
    sql:${TABLE}.Source_uri;;
  }
  dimension: Spotify_source{
    label:"Spotify Source"
    type: string
    sql:${TABLE}.Spotify_source;;
  }
  dimension: Isrc{
    label:"ISRC"
    type: string
    sql:${TABLE}.Isrc;;
  }
  dimension: Labelid{
    label:"Label ID"
    type: string
    sql:${TABLE}.Labelid;;
  }
  dimension: Transaction_country_code{
    label:"Transaction Country Code"
    type: string
    sql:${TABLE}.Transaction_country_code;;
  }
  dimension: User_gender{
    label:"User Gender"
    type: string
    sql:${TABLE}.User_gender;;
  }
  dimension: User_age_group{
    label:"User Age Group"
    type: string
    sql:${TABLE}.User_age_group;;
  }
  dimension: Source_type_detail{
    label:"Source Type Detail"
    type: string
    sql:${TABLE}.Source_type_detail;;
  }
  dimension: Source_type_buckets{
    label:"Source Type Buckets"
    type: string
    sql:${TABLE}.Source_type_buckets;;
  }
  dimension: Playlist_name{
    label:"Playlist Name"
    type: string
    sql:${TABLE}.Playlist_name;;
  }
  measure: Discovery_streams{
    label:"Discovery Streams"
    type: sum
    sql:${TABLE}.Discovery_streams;;
  }
  measure: Streams{
    label:"Streams"
    type: sum
    sql:${TABLE}.Streams;;
  }

}