label: "KNR Models"
connection: "knr-looker"

include: "/views/performer_salesforce_society.view.lkml"
include: "/views/performer_salesforce_contributor.view.lkml"
include: "/views/nr_contributor.view.lkml"

# =========================================================================
# EXPLORE: SALESFORCE PERFORMER CONTRIBUTOR & SOCIETY
# =========================================================================
explore: performer_salesforce_contributor {
  hidden: no
  label: "Salesforce Performer Contributor & Society"
  view_name: performer_salesforce_contributor

  join: performer_salesforce_society {
    type: left_outer
    relationship: one_to_many
    sql_on: ${performer_salesforce_contributor.id} = ${performer_salesforce_society.contributor_c} ;;
  }

  join: nr_contributor {
    type: left_outer
    relationship: many_to_one
    sql_on: ${performer_salesforce_contributor.contributor_uuid_c} = ${nr_contributor.id} ;;
  }
}