view: int_dbt_prod_promusicae_brazil_cert {
  sql_table_name: INTELLIGENCE.DBT_PROD.PROMUSICAE_BRAZIL_CERTIFICATION ;;

  dimension_group: download_activity_date {
    view_label: "Date"
    label: "Activity"
    type: time
    sql: ${TABLE}.download_activity_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: 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: "Promusicae"
    value_format: "#,##0"
  }

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

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

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

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

}