view: int_dbt_prod_aria_track_cert {
  sql_table_name: INTELLIGENCE.DBT_PROD.ARIA_TRACK_CERTIFICATION ;;

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

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

  dimension: labelid {
    label: "Label ID"
    type: string
    sql: ${TABLE}.labelid ;;
    view_label: "Label"
  }

  dimension: label_name {
    label: "Label Name"
    type: string
    sql: ${TABLE}.label_name ;;
    view_label: "Label"
  }

  dimension: label_manager {
    label: "Primary Relationship Manager"
    type: string
    sql: ${TABLE}.label_manager ;;
    view_label: "Label"
  }

  dimension: artistid {
    label: "Artist ID"
    type: number
    sql: ${TABLE}.artistid ;;
    view_label: "Artist"
  }

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

  dimension: brand_name {
    type: string
    full_suggestions: no
    sql: ${TABLE}.brand_name ;;
    view_label: "Label"
    description: "Name of the company to which the label belongs. Can be awal, orchard, sme"
  }

  dimension: service_tier_name {
    type: string
    full_suggestions: no
    sql: ${TABLE}.service_tier_name ;;
    view_label: "Label"
    description: "Client tier the label falls into as per the tiers."
  }

  measure: ad_supported_units {
    label: "Ad Supported Units"
    type: sum
    sql: ${TABLE}.ad_supported_units ;;
    view_label: "Aria"
    value_format: "#,##0"
  }

  measure: subscription_units {
    label: "Subscription Units"
    type: sum
    sql: ${TABLE}.subscription_units ;;
    view_label: "Aria"
    value_format: "#,##0"
  }

  measure: ad_supported_streams {
    label: "Ad-Supported Streams"
    type: sum
    sql: ${TABLE}.ad_supported_streams ;;
    view_label: "Aria"
  }

  measure: subscription_streams {
    label: "Subscription Streams"
    type: sum
    sql: ${TABLE}.subscription_streams ;;
    view_label: "Aria"
  }

  measure: single_downloads {
    label: "Single Downloads"
    type: sum
    sql: ${TABLE}.single_downloads ;;
    view_label: "Aria"
  }

  measure: sea_streaming_score {
    label: "SEA Score"
    description: "Sum of ad supported and subscription units"
    type: sum
    value_format: "#,##0"
    sql: ${TABLE}.sea_streaming_score ;;
    view_label: "Aria"
  }

}