explores/vector_customers.view.lkml

include: "/views/vector/customers.view.lkml"
include: "/views/nal.view.lkml"
# include: "/views/revenue/account_sort.view.lkml"
# include: "/views/account_stats.view.lkml"
# include: "/views/apac_account_metadata.view.lkml"
explore: vector_customers {
  view_label: "Account"
  description: "Contains data on vector customers sourced from Vector, Anaplan and MDM"
  join: nal {
    view_label: "Account"
    sql_on: ${vector_customers.nal_id} = ${nal.nal_id} ;;
    type: left_outer
    relationship: many_to_one
  }
  # join: account_sort {
  #   type: left_outer
  #   sql: ${vector_customers.reporting_id} = ${account_sort.reporting_id} ;;
  #   relationship: many_to_one
  # }
  # join: account_stats {
  #   view_label: "Account"
  #   sql_on: ${account_stats.reporting_id} = ${vector_customers.reporting_id} ;;
  #   relationship: many_to_one
  #   fields: [account_stats.rainbow_fields*]
  # }
  # join: apac_account_metadata {
  #   view_label: "Account"
  #   sql_on: ${apac_account_metadata.reporting_id} = ${vector_customers.reporting_id} ;;
  #   type: left_outer
  #   relationship: many_to_one
  # }
}