-
Notifications
You must be signed in to change notification settings - Fork 0
/
thelook.model.lkml
78 lines (68 loc) · 1.43 KB
/
thelook.model.lkml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
connection: "thelook"
# include all the views
include: "*.view"
# include all the dashboards
include: "*.dashboard"
explore: events {
hidden: yes
join: users {
type: left_outer
sql_on: ${events.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
explore: inventory_items {
hidden: yes
join: products {
type: left_outer
sql_on: ${inventory_items.product_id} = ${products.id} ;;
relationship: many_to_one
}
}
explore: order_items {
hidden: yes
join: inventory_items {
type: left_outer
sql_on: ${order_items.inventory_item_id} = ${inventory_items.id} ;;
relationship: many_to_one
}
join: orders {
type: left_outer
sql_on: ${order_items.order_id} = ${orders.id} ;;
relationship: many_to_one
}
join: products {
type: left_outer
sql_on: ${inventory_items.product_id} = ${products.id} ;;
relationship: many_to_one
}
join: users {
type: left_outer
sql_on: ${orders.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
explore: orders {
hidden: yes
join: users {
type: left_outer
sql_on: ${orders.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
# explore: products {}
#
# explore: schema_migrations {}
#
# explore: user_data {
# hidden: yes
# join: users {
# type: left_outer
# sql_on: ${user_data.user_id} = ${users.id} ;;
# relationship: many_to_one
# }
# }
#
# explore: users {}
#
# explore: users_nn {}