view: int_dbt_prod_release_compare_model_apple_playlist {
  sql_table_name:"INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_PLAYLIST";;


  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: number
    sql:${TABLE}.Subaccount_id;;
  }
  dimension: Subaccount_name{
    label:"Subaccount Name"
    type: string
    sql:${TABLE}.Subaccount_name;;
  }
  dimension: Artist_id{
    label:"Artist ID"
    type: number
    sql:${TABLE}.Artist_id;;
  }
  dimension: Artist_name{
    label:"Artist Name"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension_group: Download_activity_date{
    label:"Download Activity Date"
    type: time
    sql:${TABLE}.Download_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: Isrc{
    label:"ISRC"
    type: string
    sql:${TABLE}.Isrc;;
  }
  dimension: Labelid{
    label:"Label ID"
    type: number
    sql:${TABLE}.Labelid;;
  }
  dimension: Transaction_country_code{
    label:"Transaction Country Code"
    type: string
    sql:${TABLE}.Transaction_country_code;;
  }
  dimension: Source_of_stream_breakdown{
    label:"Source of Stream Breakdown"
    type: string
    sql:${TABLE}.Source_of_stream_breakdown;;
  }
  dimension: Source_of_stream{
    label:"Source of Stream"
    type: string
    sql:${TABLE}.Source_of_stream;;
  }
  dimension: Playlist_name{
    label:"Playlist Name"
    type: string
    sql:${TABLE}.Playlist_name;;
  }
  dimension: Playlist_id{
    label:"Playlist ID"
    type: string
    sql:${TABLE}.Playlist_id;;
  }
  dimension: Playlist_type{
    label:"Playlist Type"
    type: string
    sql:${TABLE}.Playlist_type;;
  }
  dimension: Playlist_author{
    label:"Playlist Author"
    type: string
    sql:${TABLE}.Playlist_author;;
  }
  dimension: Playlist_url{
    label:"Playlist URL"
    type: string
    sql:${TABLE}.Playlist_url;;
  }
  measure: Streams{
    label:"Streams"
    type: sum
    sql:${TABLE}.Streams;;
  }

}