view: int_dbt_prod_release_compare_model_apple_store {
  sql_table_name:"INTELLIGENCE"."DBT_PROD"."RELEASE_COMPARE_MODEL_APPLE_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: Download_date{
    label:"Download Date"
    type: time
    sql:${TABLE}.Download_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: string
    sql:${TABLE}.Labelid;;
  }
  dimension: Transaction_country_code{
    label:"Transaction Country Code"
    type: string
    sql:${TABLE}.Transaction_country_code;;
  }
  dimension: Source_of_stream_groupings{
    label:"Source Of Stream Groupings"
    type: string
    sql:${TABLE}.Source_of_stream_groupings;;
  }
  measure: Streams{
    label:"Streams"
    type: sum
    sql:${TABLE}.Streams;;
  }

}