view: int_dbt_prod_communion_amazon_daily_data {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."COMMUNION_AMAZON_DAILY_DATA" ;;

  dimension: download_activity_date {
    type: date
    sql: ${TABLE}.DOWNLOAD_ACTIVITY_DATE ;;
    label: "Dataset Date"
  }

  dimension: subscription_plan {
    type: string
    sql: ${TABLE}.SUBSCRIPTION_PLAN ;;
  }

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

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

  dimension: upc {
    type: string
    label: "UPC"
    sql: ${TABLE}.UPC ;;
  }

  dimension: device_type {
    type: string
    sql: ${TABLE}.DEVICE_TYPE ;;
  }

  dimension: source_of_stream {
    type: string
    sql: ${TABLE}.SOURCE_OF_STREAM ;;
  }

  dimension: playlist_name {
    type: string
    sql: ${TABLE}.PLAYLIST_NAME ;;
  }

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

  dimension: postal_code {
    type: string
    sql: ${TABLE}.POSTAL_CODE ;;
  }

  measure: stream_length {
    type: sum
    sql: ${TABLE}.STREAM_LENGTH ;;
  }

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

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

  measure: number_of_users {
    type: sum
    sql: ${TABLE}.NUMBER_OF_USERS ;;
  }

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

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

  dimension: version {
    type: string
    sql: ${TABLE}.VERSION ;;
  }

  dimension: format {
    type: string
    sql: ${TABLE}.FORMAT ;;
  }

  dimension: genre {
    type: string
    sql: ${TABLE}.GENRE ;;
  }

  dimension: trackname {
    type: string
    label: "Track Name"
    sql: ${TABLE}.TRACKNAME ;;
  }

  dimension: stream_source_id {
    type: string
    label: "Source of Stream ID"
    sql: ${TABLE}.stream_source_id ;;
  }
}