view: int_dbt_prod_saregama_apple_daily_data {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."SAREGAMA_APPLE_DAILY_DATA" ;;

  dimension: download_date {
    type: date
    sql: ${TABLE}.DOWNLOAD_DATE ;;
    label: "Dataset Date"
  }

  dimension: country_code {
    type: string
    sql: ${TABLE}.COUNTRY_CODE ;;
  }

  dimension: apple_id {
    type: number
    sql: ${TABLE}.APPLE_ID ;;
    label: "Apple ID"
  }

  dimension: isrc {
    type: string
    sql: ${TABLE}.ISRC ;;
  }

  dimension: artist_name {
    type: string
    sql: ${TABLE}.ARTIST_NAME ;;
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.UPC ;;
  }

  dimension: audio_format {
    type: string
    sql: ${TABLE}.AUDIO_FORMAT ;;
  }

  dimension: subscription_type {
    type: string
    sql: ${TABLE}.SUBSCRIPTION_TYPE ;;
  }

  dimension: subscription_mode {
    type: string
    sql: ${TABLE}.SUBSCRIPTION_MODE ;;
  }

  dimension: container_id {
    type: string
    sql: ${TABLE}.CONTAINER_ID ;;
  }

  dimension: container_name {
    type: string
    sql: ${TABLE}.CONTAINER_NAME ;;
  }

  dimension: channel_partner {
    type: string
    sql: ${TABLE}.CHANNEL_PARTNER ;;
  }

  dimension: stream_source {
    type: string
    sql: ${TABLE}.STREAM_SOURCE ;;
  }

  dimension: online_offline {
    type: string
    sql: ${TABLE}.ONLINE_OFFLINE ;;
    label: "Online/ Offline"
  }

  dimension: device {
    type: string
    sql: ${TABLE}.DEVICE ;;
  }

  measure: streams {
    type: sum
    sql: ${TABLE}.STREAMS ;;
  }

  measure: skips {
    type: sum
    sql: ${TABLE}.SKIPS ;;
  }

  dimension: release_name {
    type: string
    sql: ${TABLE}.RELEASE_NAME ;;
  }

  dimension: release_date {
    type: date
    sql: ${TABLE}.RELEASE_DATE ;;
  }

  dimension: trackname {
    type: string
    sql: ${TABLE}.TRACKNAME ;;
  }
}