view: orchadmin_users_snowflake {
    sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users ;;

    dimension: id {
      primary_key: yes
      type: number
      sql: ${TABLE}.id ;;
    }

    dimension: active {
      type: string
      sql: ${TABLE}.active ;;
    }

    dimension: alt_phone {
      type: string
      sql: ${TABLE}.alt_phone ;;
    }

#     dimension: is_closer {
#       type: string
#       sql: ${TABLE}.closer ;;
#     }

    dimension: department {
      type: string
      sql: ${TABLE}.department ;;
    }

    dimension: display {
      type: string
      sql: ${TABLE}.display ;;
    }

    dimension: email {
      type: string
      sql: ${TABLE}.email ;;
    }

    dimension: extension {
      type: number
      sql: ${TABLE}.extension ;;
    }

    dimension: full_name {
      label: "
      {% if _view._name == 'orchadmin_users_snowflake' %} Label Manager
      {% elsif _view._name == 'proper_user' %} User who carved out Proper
      {% elsif _view._name == 'direct_shot_user' %} User who carved out Direct Shot
      {% elsif _view._name == 'wheels_user' %} User who carved out Wheels
      {% elsif _view._name == 'mgm_user' %} User who carved out MGM
      {% elsif _view._name == 'membran_user' %} User who carved out Membran
      {% else %} Label Manager {% endif %}"
      type: string
      sql: concat(${f_name},concat(' ',${l_name})) ;;

    }

   dimension: closer_full_name {
    label: "Closer"
     type: string
     sql: concat(${f_name},concat(' ',${l_name})) ;;
  }

  dimension: quarterback_label_manager {
    label: "Quarterback Label Manager"
    type: string
    sql: concat(${f_name},concat(' ',${l_name})) ;;
  }

    dimension: f_name {
      type: string
      sql: ${TABLE}.f_name ;;
    }

    dimension: l_name {
      type: string
      sql: ${TABLE}.l_name ;;
    }

    dimension: last_search {
      type: string
      sql: ${TABLE}.last_search ;;
    }

    dimension: login {
      type: string
      sql: ${TABLE}.login ;;
    }

    dimension: office_location {
      type: string
      sql: ${TABLE}.office_location ;;
    }

    dimension: office_phone {
      type: string
      sql: ${TABLE}.office_phone ;;
    }

    dimension: old_password {
      type: string
      sql: ${TABLE}.old_password ;;
    }

    dimension: owner {
      type: string
      sql: ${TABLE}.owner ;;
    }

    dimension: pass {
      type: string
      sql: ${TABLE}.pass ;;
    }

    dimension: password {
      type: string
      sql: ${TABLE}.password ;;
    }

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

    dimension: password_request_key {
      type: string
      sql: ${TABLE}.password_request_key ;;
    }

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

    dimension: role {
      type: number
      sql: ${TABLE}.role ;;
    }

    dimension: title {
      type: string
      sql: ${TABLE}.title ;;
    }

    measure: count {
      type: count
      drill_fields: [detail*]
    }

    # ----- Sets of fields for drilling ------
    set: detail {
      fields: [
        id,
        agreement_note.count,
        cd_receive.count,
        customer_return.count,
        deal_info_notes.count,
        digital_deletions.count,
        encoding_order.count,
        full_deletions.count,
        mass_mailer_log.count,
        master_pitch.count,
        meta_update_queue.count,
        mm_package.count,
        note.count,
        oms_client_notes.count,
        oms_label_deal_owner.count,
        oms_project_owner.count,
        oms_task_owner.count,
        orchadmin_user_permission.count,
        orchadmin_user_roles.count,
        orchadmin_user_saved_query.count,
        order_shipping.count,
        ringtone_order.count,
        vendor_contract_change_history.count,
        vendor_proposed_term_change_history.count,
        vendor_tmp.count,
        youtube_channel_cms_account_history.count,
        youtube_channel_partner_status_history.count,
        youtube_channel_service_tier_history.count
      ]
    }
  }