view: dim_subaccount {
  sql_table_name: facts.prod.DIM_SUBACCOUNT ;;

  dimension: city {
    sql: ${TABLE}.CITY ;;
  }

  dimension: commission_override {
    sql: ${TABLE}.COMMISSIONOVERRIDE ;;
  }

  dimension: country {
    sql: ${TABLE}.COUNTRY ;;
  }

  dimension_group: date_created {
    type: time
    timeframes: [date,week,month,year]
    sql: ${TABLE}.DATE_CREATED ;;
  }

  dimension_group: date_deleted {
    type: time
    timeframes: [date,week,month,year]
    sql: ${TABLE}.DATE_DELETED ;;
  }

  dimension: description {
    sql: ${TABLE}.DESCRIPTION ;;
  }

  dimension: label_id {
    sql: ${TABLE}.LABELID ;;
  }

  dimension_group: last_updated {
    type: time
    timeframes: [date,week,month,year]
    sql: ${TABLE}.LAST_UPDATED ;;
  }

  dimension: myspace_url {
    sql: ${TABLE}.MYSPACEURL ;;
  }

  dimension: primary_genre {
    sql: ${TABLE}.PRIMARYGENRE ;;
  }

  dimension: state_province {
    sql: ${TABLE}.STATEPROVINCE ;;
  }

  dimension: subaccount_id {
    primary_key: yes
    sql: ${TABLE}.SUBACCOUNTID ;;
  }

  dimension: subaccount_name {
    sql: ${TABLE}.SUBACCOUNTNAME ;;
  }

  dimension: website_url {
    sql: ${TABLE}.WEBSITEURL ;;
  }

  measure: number_of_subaccounts {
    type: count_distinct
    sql: ${subaccount_id};;
  }
}