Segment_Zola_Sales_Test.model.lkml

connection: "dwh3"

# include all views in this project
# - include: "*.dashboard.lookml"  # include all dashboards in this project
include: "*.view"

# - explore: screens

# explore: screens {
# Unused Explore BI-2868
#   view_label: "Zola Sales Screens"
#   label: "Zola Sales Screens"
# }

# explore: event_facts {
# Unused Explore BI-2868
#   view_label: "Events"
#   label: "Events"

#   join: pages {
#     view_label: "Events"
#     type: left_outer
#     sql_on: event_facts.uuid = pages.uuid
#       and event_facts.received_at = pages.received_at
#       and event_facts.anonymous_id = pages.anonymous_id
#       ;;
#     relationship: one_to_one
#   }

#   join: tracks {
#     view_label: "Events"
#     type: left_outer
#     sql_on: event_facts.event_id = concat(tracks.event_id, '-t')
#       and event_facts.received_at = tracks.received_at
#       and event_facts.anonymous_id = tracks.anonymous_id
#       ;;
#     relationship: one_to_one
#     fields: []
#   }

#   join: page_facts {
#     view_label: "Events"
#     type: left_outer
#     sql_on: event_facts.event_id = page_facts.event_id and
#       event_facts.received_at = page_facts.received_at and
#       event_facts.looker_visitor_id = page_facts.looker_visitor_id
#       ;;
#     relationship: one_to_one
#   }

#   join: sessions_pg_trk {
#     view_label: "Sessions"
#     type: left_outer
#     sql_on: ${event_facts.session_id} = ${sessions_pg_trk.session_id} ;;
#     relationship: many_to_one
#   }

#   join: session_pg_trk_facts {
#     view_label: "Sessions"
#     type: left_outer
#     sql_on: ${event_facts.session_id} = ${session_pg_trk_facts.session_id} ;;
#     relationship: many_to_one
#   }
# }

# explore: track_facts {
# Unused Explore BI-2868
#   view_label: "Events"
#   label: "Events"

#   join: tracks {
#     view_label: "Events"
#     type: left_outer
#     relationship: one_to_one
#     sql_on: tracks.uuid = track_facts.uuid and
#       tracks.received_at = track_facts.received_at and
#       tracks.anonymous_id = track_facts.anonymous_id
#       ;;
#   }

#   join: sessions_trk {
#     view_label: "Sessions"
#     type: left_outer
#     sql_on: ${track_facts.session_id} = ${sessions_trk.session_id} ;;
#     relationship: many_to_one
#   }

#   join: session_trk_facts {
#     view_label: "Sessions"
#     type: left_outer
#     sql_on: ${track_facts.session_id} = ${session_trk_facts.session_id} ;;
#     relationship: many_to_one
#   }

#   join: user_session_facts {
#     view_label: "Users"
#     type: left_outer
#     sql_on: ${track_facts.looker_visitor_id} = ${user_session_facts.looker_visitor_id} ;;
#     relationship: many_to_one
#   }
#   join: users {
#     view_label: "Users"
#     type: left_outer
#     sql_on: ${user_session_facts.looker_visitor_id} = ${users.id} ;;
#     relationship: one_to_one
#   }

#   join: tracks_flow {
#     view_label: "Events Flow"
#     sql_on: ${track_facts.event_id} = ${tracks_flow.event_id} ;;
#     relationship: one_to_one
#   }
# }

# explore: sessions_trk {
# Unused Explore BI-2868
#   join: session_trk_facts {
#     view_label: "sessions"
#     sql_on: ${sessions_trk.session_id} = ${session_trk_facts.session_id} ;;
#     relationship: one_to_one
#   }

#   join: user_session_facts {
#     view_label: "Users"
#     sql_on: ${sessions_trk.looker_visitor_id} = ${user_session_facts.looker_visitor_id} ;;
#     relationship: many_to_one
#   }
# }

# explore: funnel_explorer {
# Unused Explore BI-2868
#   join: sessions_trk {
#     view_label: "sessions"
#     foreign_key: session_id
#   }

#   join: user_session_facts {
#     view_label: "Users"
#     foreign_key: sessions_trk.looker_visitor_id
#   }

#   join: session_trk_facts {
#     view_label: "sessions"
#     relationship: one_to_one
#     foreign_key: session_id
#   }

#   join: users {
#     relationship: many_to_one
#     sql_on: coalesce(users.mapped_user_id, users.user_id) = sessions.user_id ;;
#   }
# }