Skip to content

Instantly share code, notes, and snippets.

@mattm
Created April 6, 2018 18:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattm/aa48996d0e32e1dc3d574ed85d9099d1 to your computer and use it in GitHub Desktop.
Save mattm/aa48996d0e32e1dc3d574ed85d9099d1 to your computer and use it in GitHub Desktop.
Mixpanel Looker Model
connection: "bigquery"
include: "*.view.lkml"
explore: mp_events {
view_label: "Mixpanel"
label: "Mixpanel"
sql_always_where: STRPOS(${full_url}, "https://www.helpscout.net") = 1 OR STRPOS(${full_url}, "https://secure.helpscout.net") = 1 ;;
join: mp_companies {
view_label: "Mixpanel"
type: left_outer
relationship: many_to_one
sql_on: ${mp_companies.distinct_id} = ${mp_events.distinct_id} ;;
}
join: helpscout_companies {
view_label: "Company"
relationship: one_to_one
sql_on: ${helpscout_companies.com_id} = ${mp_companies.com_id} ;;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment