view: int_dbt_prod_riaa_album_cert {
  sql_table_name: INTELLIGENCE.DBT_PROD.RIAA_ALBUM_CERTIFICATION ;;

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

  dimension: release_name {
    type: string
    label: "Release Name"
    view_label: "Release"
    sql: ${TABLE}.RELEASENAME ;;
  }

  dimension_group: release_date {
    type: time
    label: "Release"
    view_label: "Release"
    timeframes: [raw, date, week, month, quarter, year]
    sql: ${TABLE}.RELEASEDATE ;;
  }

  dimension: label_id {
    type: number
    label: "Label ID"
    view_label: "Label"
    sql: ${TABLE}.LABELID ;;
  }

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

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

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

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

  dimension: activity_period {
    type: string
    label: "Activity Period"
    view_label: "Riaa"
    sql: ${TABLE}.ACTIVITY_PERIOD ;;
  }

  dimension_group: activity_date {
    type: time
    label: "Activity Date"
    timeframes: [raw, date, week, month, quarter, year]
    view_label: "Riaa"
    sql: TO_DATE(CONCAT(${TABLE}.ACTIVITY_PERIOD, '-01'), 'YYYY-MM-DD') ;;
  }

  dimension: service_tier_name {
    type: string
    label: "Service Tier Name"
    view_label: "Riaa"
    sql: ${TABLE}.SERVICE_TIER_NAME ;;
    hidden: yes
  }

  dimension: store {
    type: string
    label: "Store Name"
    view_label: "Riaa"
    sql: ${TABLE}.storename ;;
  }

  measure: subscription_streams {
    type: sum
    label: "Subscription Stream"
    view_label: "Riaa"
    sql: ${TABLE}."Subscription Streams" ;;
    value_format_name: decimal_0
  }

  measure: ad_supported_streams {
    type: sum
    label: "Ad Supported Stream"
    view_label: "Riaa"
    sql: ${TABLE}."Ad-Supported Streams" ;;
    value_format_name: decimal_0
  }

  measure: track_downloads {
    type: sum
    label: "Track Downloads"
    view_label: "Riaa"
    sql: ${TABLE}."Track Downloads" ;;
    value_format_name: decimal_0
  }

  measure: album_downloads {
    type: sum
    label: "Album Downloads"
    view_label: "Riaa"
    sql: ${TABLE}."Album Downloads" ;;
    value_format_name: decimal_0
  }

  measure: certification_units {
    type: sum
    label: "Certification Units"
    view_label: "Riaa"
    sql: ${TABLE}.CERTIFICATION_UNITS ;;
    value_format_name: decimal_0
  }
}