view: APPLE_IN_REVIEW{
  sql_table_name:INTELLIGENCE.DBT_PROD.APPLE_IN_REVIEW;;


  dimension: APPLE_ID{
    label:"APPLE ID"
    view_label: "Track"
    description: "Apple ID associated with the track"
    type: number
    sql:${TABLE}.APPLE_ID;;
  }
  dimension: ARTIST_NAME{
    view_label: "Artist"
    description: "Name of the artist as reported by the store"
    label:"ARTIST NAME"
    type: string
    sql:${TABLE}.ARTIST_NAME;;
  }
  dimension: TRACK_NAME{
    view_label: "Track"
    label:"TRACK NAME"
    description: "Track name provided by store"
    type: string
    sql:${TABLE}.TRACK_NAME;;
  }
  dimension: COUNTRY_CODE{
    label:"COUNTRY CODE"
    description: "Alphabetical code associated with the country of consumption"
    hidden: yes
    type: string
    sql:${TABLE}.COUNTRY_CODE;;
  }
  dimension: SUBSCRIPTION_TYPE{
    view_label: "Subscription"
    label:"SUBSCRIPTION TYPE"
    description: "Exact name of the subscription plan held by the user"
    type: string
    sql:${TABLE}.SUBSCRIPTION_TYPE;;
  }
  dimension: SUBSCRIPTION_MODE{
    view_label: "Subscription"
    label:"SUBSCRIPTION MODE"
    description: "Type of subscription a the user holds (Paid, Trial etc)"
    type: string
    sql:${TABLE}.SUBSCRIPTION_MODE;;
  }
  dimension: CHANNEL_PARTNER{
    label:"CHANNEL PARTNER"
    view_label: "Subscription"
    description: "Note: This is usually null for all entries"
    hidden: yes
    type: string
    sql:${TABLE}.CHANNEL_PARTNER;;
  }
  dimension: DEVICE_TYPE{
    view_label: "Device"
    description: "Type of device a track was streamed on (Mobile, Laptop etc)"
    label:"DEVICE TYPE"
    type: string
    sql:${TABLE}.DEVICE_TYPE;;
  }
  dimension: DEVICE_OS{
    view_label: "Device"
    description: "Operating System of the device the track was streamed on"
    label:"DEVICE OS"
    type: string
    sql:${TABLE}.DEVICE_OS;;
  }
  dimension: SOURCE_OF_STREAM{
    view_label: "Source of Stream"
    label:"SOURCE OF STREAM"
    type: string
    description: "Source of stream from the platform (Library, Search etc)"
    sql:${TABLE}.SOURCE_OF_STREAM;;
  }
  dimension: CONTAINER_SUB_TYPE{
    label:"CONTAINER SUB TYPE"
    description: "Actual source(subset of the source of stream) from the DSP"
    view_label: "Source of Stream"
    type: string
    sql:${TABLE}.CONTAINER_SUB_TYPE;;
  }
  dimension: CONTAINER_NAME{
    view_label: "Source of Stream"
    description: "Note: This is usually null for all entries"
    hidden: yes
    label:"CONTAINER NAME"
    type: string
    sql:${TABLE}.CONTAINER_NAME;;
  }
  dimension: CONTAINER_ID{
    view_label: "Source of Stream"
    label:"CONTAINER ID"
    description: "Note: This is usually null for all entries"
    hidden: yes
    type: string
    sql:${TABLE}.CONTAINER_ID;;
  }
  dimension: REASON_OF_ENDING{
    view_label: "User"
    label:"REASON OF ENDING"
    description: "Reason the track stream was ended by the user"
    type: string
    sql:${TABLE}.REASON_OF_ENDING;;
  }
  dimension: AUDIO_FORMAT{
    view_label: "Track"
    description: "Format of the audio as on the store (Compressed/ Lossless)"
    label:"AUDIO_FORMAT"
    type: string
    sql:${TABLE}.AUDIO_FORMAT;;
  }
  dimension: GENDER{
    view_label: "User"
    label:"GENDER"
    description: "Gender of the user who streamed the track"
    type: string
    sql:${TABLE}.GENDER;;
  }
  dimension: AGE_BUCKET{
    view_label: "User"
    label:"AGE_BUCKET"
    description: "Age bracket for the user who streamed the track"
    type: string
    sql:${TABLE}.AGE_BUCKET;;
  }
  dimension_group: REPORT_DATE{
    description: "The most recent date a track appeared in the report"
    label:"Report"
    type: time
    sql:${TABLE}.REPORT_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: UPC{
    view_label: "Release"
    label:"UPC"
    description: "Unique Product Code for each release"
    type: string
    sql:${TABLE}.UPC;;
  }
  dimension: ISRC{
    view_label: "Track"
    label:"ISRC"
    description: "ISRC of the track"
    type: string
    sql:${TABLE}.ISRC;;
  }
  dimension: LABEL_ID{
    view_label: "Label"
    label:"LABEL_ID"
    description: "Unique ID for the label under which the release is"
    type: string
    sql:${TABLE}.LABEL_ID;;
  }

  measure: STREAMS {
    label: "STREAMS"
    description: "Number of streams blocked for review for a track"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.STREAMS ;;
  }
    }