-
Notifications
You must be signed in to change notification settings - Fork 0
/
dean_test_old.model.lkml
97 lines (71 loc) · 1.69 KB
/
dean_test_old.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
connection: "the_look"
# include all the views
include: "*.view"
datagroup: test_datagroup {
max_cache_age: "9 hours"
sql_trigger: CURRENT_DATE() ;;
}
#testing changes#
explore: connection_reg_r3 {}
explore: derived_test_table_3_20190510 {}
explore: events {
join: users {
type: left_outer
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: orders {
type: left_outer
sql_on: ${order_items.order_id} = ${orders.id} ;;
relationship: many_to_one
}
join: inventory_items {
type: left_outer
sql_on: ${order_items.inventory_item_id} = ${inventory_items.id} ;;
relationship: many_to_one
}
join: users {
type: left_outer
sql_on: ${orders.user_id} = ${users.id} ;;
relationship: many_to_one
}
join: products {
type: left_outer
sql_on: ${inventory_items.product_id} = ${products.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: schema_migrations {}
explore: user_data {
join: users {
type: left_outer
sql_on: ${user_data.user_id} = ${users.id} ;;
relationship: many_to_one
}
}
explore: users {
# sql_always_where: ${users.state} IN ({{ _user_attributes['state'] }}) ;;
}
explore: users_nn {}
explore: zozo_table_20190507 {}
explore: zozo_table_20190508 {}
explore: zozo_table_null {}
explore: test_lookup_new {}
explore: testing_explore {}