-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsara_ramp_model.model.lkml
121 lines (96 loc) · 3 KB
/
sara_ramp_model.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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
connection: "thelook"
# include all the views
include: "*.view"
# include all the dashboards
# include: "*.dashboard"
explore: schema_migrations {}
explore: events {
join: users {
type: left_outer
from: events
sql_on: ${events.user_id} = ${users.id} ;;
relationship: many_to_one
}
join: users2 {
type: left_outer
from: events
sql_on: ${events.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
explore: inventory_items {
join: products {
type: left_outer
sql_on: ${inventory_items.product_id} = ${products.id} ;;
relationship: many_to_one
}
}
explore: order_items {
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 {
join: users {
type: left_outer
sql_on: ${orders.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
explore: products {}
explore: user_data {
join: users {
type: left_outer
sql_on: ${user_data.user_id} = ${users.id} ;;
relationship: many_to_one
}
join: orders {
type: left_outer
relationship: one_to_many
sql: ${users.id} = ${orders.user_id} ;;
}
}
explore: users {}
explore: users_nn {}
explore: customer_order_facts {}
# x At least three Explores. Amongst the three, there should be:
# x An Explore that is cached for 4 hours (hint: read about datagroups! (hint 2: persist_with:))
# x A join that uses the 'fields' parameter
# x An Explore that uses the 'always_filter' parameter
# x An Explore that uses the 'sql_always_where' parameter
# x A join that uses the 'view_label' parameter
# x A join that is an INNER join
# x A view that is joined into the same Explore twice
# x One dimension of each of the following types
# x Number, case, string, tier, zipcode, yesno
# x One measure of each of the following types
# x Min, max, average, sum, sum_distinct
# x At least one filtered measure
# x A measure that references multiple measures in its definition <- what does this mean???
# x A dimension/measure that references a field from another view - allowed as long as the join is defined in the model
# A drill path for every measure, and a couple dimensions (maybe a tier / location).
# Labels and descriptions for at least 5 custom fields (fields that were not built by the generator)
# At least 2 User Defined dashboards
# Each dashboard should have at least 2 global filters
# Together, the dashboards should contain at least one of every available visualization type
# One LookML dashboard
# x Value formats name for:
# x A percentage dimension/measure
# x A dollar amount dimension/measure