forked from looker/block-redshift-admin
-
Notifications
You must be signed in to change notification settings - Fork 4
/
redshift_admin.dashboard.lookml
105 lines (105 loc) · 3.21 KB
/
redshift_admin.dashboard.lookml
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
- dashboard: redshift_admin
preferred_viewer: dashboards-next
title: Redshift Admin
layout: newspaper
query_timezone: query_saved
elements:
- title: Table Load Summary
name: Table Load Summary
model: block_redshift_admin_v2
explore: redshift_data_loads
type: table
fields: [redshift_data_loads.root_bucket, redshift_data_loads.s3_path_clean, redshift_data_loads.file_stem,
redshift_data_loads.hours_since_last_load]
sorts: [redshift_data_loads.root_bucket]
limit: 500
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: gray
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 0
col: 2
width: 20
height: 13
- title: Recent Files Loaded
name: Recent Files Loaded
model: block_redshift_admin_v2
explore: redshift_data_loads
type: table
fields: [redshift_data_loads.file_name, redshift_data_loads.hours_since_last_load]
filters:
redshift_data_loads.load_date: 3 hours
sorts: [redshift_data_loads.hours_since_last_load]
limit: 500
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: gray
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 26
col: 2
width: 20
height: 14
- title: Recent Load Errors
name: Recent Load Errors
model: block_redshift_admin_v2
explore: redshift_etl_errors
type: table
fields: [redshift_etl_errors.error_date, redshift_etl_errors.file_name, redshift_etl_errors.column_name,
redshift_etl_errors.column_data_type, redshift_etl_errors.error_reason]
filters:
redshift_etl_errors.error_date: 7 days
sorts: [redshift_etl_errors.error_date desc]
limit: 500
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: gray
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 40
col: 2
width: 20
height: 13
- title: Database Consumption
name: Database Consumption
model: block_redshift_admin_v2
explore: redshift_db_space
type: table
fields: [redshift_db_space.schema, redshift_db_space.table_stem, redshift_db_space.total_rows,
redshift_db_space.total_megabytes, redshift_db_space.total_tables]
sorts: [redshift_db_space.total_megabytes desc]
limit: 500
show_view_names: true
show_row_numbers: true
truncate_column_names: false
hide_totals: false
hide_row_totals: false
table_theme: gray
limit_displayed_rows: false
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 13
col: 2
width: 20
height: 13