-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstorage_zfs.view.lkml
122 lines (113 loc) · 2.38 KB
/
storage_zfs.view.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
122
view: storage_zfs {
sql_table_name: capacity.storage_zfs ;;
dimension_group: date {
type: time
timeframes: [
raw,
date,
week,
month,
quarter,
year
]
convert_tz: no
datatype: date
sql: ${TABLE}."date" ;;
}
dimension: instance {
type: string
sql: ${TABLE}."instance" ;;
}
dimension: region {
type: string
sql: ${TABLE}."region" ;;
}
dimension: zfs_available {
type: number
sql: ${TABLE}."zfs_available" ;;
}
dimension: zfs_used {
type: number
sql: ${TABLE}."zfs_used" ;;
}
dimension: zfs_total {
type: number
sql: ${zfs_available}+${zfs_used} ;;
}
dimension: zfs_available_t {
type: number
sql: ${zfs_available}/1024.0/1024.0/1024.0/1024.0 ;;
value_format_name: decimal_2
}
dimension: zfs_used_t {
type: number
sql: ${zfs_used}/1024.0/1024.0/1024.0/1024.0 ;;
value_format_name: decimal_2
}
dimension: zfs_total_t {
type: number
sql: ${zfs_total}/1024.0/1024.0/1024.0/1024.0 ;;
value_format_name: decimal_2
}
dimension: percent_used {
type: number
sql: ${zfs_used}*100.0/${zfs_total};;
value_format_name: decimal_2
}
dimension: percent_free {
type: number
sql: ${zfs_available}*100.0/${zfs_total} ;;
value_format_name: decimal_2
}
dimension: percent_used_tier {
description:""
type: tier
tiers: [0,25,50,75,90,95,96,97,98,99,100]
sql: ${percent_used} ;;
style: relational
}
measure: count {
type: count
drill_fields: []
}
measure: sum_total {
type: sum
sql: ${zfs_total} ;;
value_format_name: decimal_2
}
measure: sum_used {
type: sum
sql: ${zfs_used} ;;
value_format_name: decimal_2
}
measure: sum_available {
type: sum
sql: ${zfs_available_t} ;;
value_format_name: decimal_2
}
measure: sum_total_t {
type: sum
sql: ${zfs_total_t} ;;
value_format_name: decimal_2
}
measure: sum_used_t {
type: sum
sql: ${zfs_used_t} ;;
value_format_name: decimal_2
}
measure: sum_available_t {
type: sum
sql: ${zfs_available} ;;
value_format_name: decimal_2
}
measure: sum_percent_free {
type: number
sql: ${sum_available}/${sum_total};;
value_format_name: decimal_2
}
measure: sum_percent_used {
type: number
sql: ${sum_used}/${sum_total} ;;
value_format_name: decimal_2
}
}