view: int_dbt_prod_communion_spotify_daily_data {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."COMMUNION_SPOTIFY_DAILY_DATA" ;;

  dimension: activity_date {
    type: date
    sql: ${TABLE}.ACTIVITY_DATE ;;
    label: "Dataset Date"
  }

  dimension: source_uri {
    type: string
    sql: ${TABLE}.SOURCE_URI ;;
  }

  dimension: spotify_source {
    type: string
    sql: ${TABLE}.SPOTIFY_SOURCE ;;
  }

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

  dimension: os {
    type: string
    sql: ${TABLE}.OS ;;
  }

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

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

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

  dimension: account_type {
    type: string
    sql: ${TABLE}.ACCOUNT_TYPE ;;
  }

  dimension: gender {
    type: string
    sql: ${TABLE}.GENDER ;;
  }

  dimension: age_group {
    type: string
    sql: ${TABLE}.AGE_GROUP ;;
  }

  measure: listening_duration {
    type: sum
    sql: ${TABLE}.LISTENING_DURATION ;;
    label: "Listening Duration (Seconds)"
  }

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

  measure: discovery_flag_streams {
    type: sum
    sql: ${TABLE}.DISCOVERY_FLAG_STREAMS ;;
  }

  dimension: artistname {
    type: string
    label: "Artist Name"
    sql: ${TABLE}.ARTISTNAME ;;
  }

  dimension: releas_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 ;;
  }
}