view: dim_label {
  sql_table_name: facts.prod.DIM_LABEL ;;

  dimension: country_id {
    sql: ${TABLE}.COUNTRYID ;;
  }

  dimension: date_created {
    sql: ${TABLE}.DATE_CREATED ;;
  }

  dimension: is_distributor {
    sql: ${TABLE}.ISDISTRIBUTOR ;;
  }

  dimension: label_id {
    primary_key: yes
    # hidden: yes
    sql: ${TABLE}.LABELID ;;
  }

  dimension: label_name {
    sql: ${TABLE}.LABELNAME ;;
  }

  dimension: last_updated {
    sql: ${TABLE}.LAST_UPDATED ;;
  }

  dimension: owner {
    sql: ${TABLE}.OWNER ;;
  }

  dimension: owner_id {
    sql: ${TABLE}.OWNERID ;;
  }

  dimension: priority {
    sql: ${TABLE}.PRIORITY ;;
  }

  dimension: is_red {
    type: yesno
    sql: ${owner} = 'RED' ;;
  }

#   measure: rows {
#     type: count
#     drill_fields: [label_name]
#   }

#   dimension: average_upcs_per_label {
#     view_label: "AVG UPCs per Label"
#     type: number
#     sql: (SELECT 73.26) ;;
#   }
#
#   dimension: average_artists_per_label {
#     view_label: "Label"
#     type: number
#     sql: (SELECT 26.24) ;;
#   }
#
#   dimension: average_tracks_per_label {
#     view_label: "Label"
#     type: number
#     sql: (SELECT 976.07) ;;
#   }
}

#test