forked from llooker/blocks_redshift_admin
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathredshift_admin.dashboard.lookml
92 lines (86 loc) · 2.95 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
- dashboard: redshift_admin
title: 'Redshift Admin'
layout: tile
tile_size: 100
elements:
- name: table_load_summary
title: 'Table Load Summary'
type: table
explore: data_loads
dimensions: [data_loads.root_bucket, data_loads.s3_path_clean, data_loads.file_stem]
measures: [data_loads.hours_since_last_load]
sorts: [data_loads.root_bucket]
model: redshift_model
explore: redshift_data_loads
dimensions: [redshift_data_loads.root_bucket, redshift_data_loads.s3_path_clean, redshift_data_loads.file_stem]
measures: [redshift_data_loads.hours_since_last_load]
sorts: [redshift_data_loads.root_bucket]
show_view_names: true
show_row_numbers: true
width: 12
height: 4
limit: 500
- name: recent_files_loaded
title: 'Recent Files Loaded'
type: table
explore: data_loads
dimensions: [data_loads.file_name]
measures: [data_loads.hours_since_last_load]
model: redshift_model
explore: redshift_data_loads
dimensions: [redshift_data_loads.file_name]
measures: [redshift_data_loads.hours_since_last_load]
filters:
redshift_data_loads.load_date: 3 hours
sorts: [redshift_data_loads.hours_since_last_load]
show_view_names: true
show_row_numbers: true
width: 12
height: 4
limit: 500
- name: recent_load_errors
title: 'Recent Load Errors'
type: table
explore: etl_errors
dimensions: [etl_errors.error_date, etl_errors.file_name, etl_errors.column_name,
etl_errors.column_data_type, etl_errors.error_reason]
model: redshift_model
explore: redshift_etl_errors
dimensions: [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]
show_view_names: true
width: 12
height: 4
limit: 500
- name: database_consumption
title: 'Database Consumption'
type: table
explore: db_space
model: redshift_model
explore: redshift_db_space
dimensions: [redshift_db_space.schema, redshift_db_space.table_stem]
measures: [redshift_db_space.total_rows, redshift_db_space.total_megabytes, redshift_db_space.total_tables]
sorts: [redshift_db_space.total_megabytes desc]
show_view_names: true
show_row_numbers: true
width: 12
height: 4
limit: 500
- name: table_architecture
title: 'Table Architecture (Distribution, Sort, and Skew)'
type: table
model: redshift_model
explore: table_skew
dimensions: [table_skew.schema, table_skew.table, table_skew.encoded, table_skew.rows_in_table,
table_skew.size, table_skew.sortkey, table_skew.distribution_style, table_skew.skew_rows]
filters:
table_skew.skew_rows: NOT NULL
sorts: [table_skew.skew_rows desc]
show_view_names: true
show_row_numbers: true
width: 12
height: 4
limit: 500