LittlerDataValidator Flow Stacked
Updated 2023-04-22
999
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
›
⌄
--labels imported from https://flowscan.org/staking/nodes/execution
with correcting_labels as (
select
case
when validator_type = project_name then null
else validator_type
end as validator_type
,node_id
,project_name
from flow.core.dim_validator_labels
),
validators as(
select
st.node_id
,validator_type
,project_name
from flow.core.ez_staking_actions st
left join correcting_labels using (node_id)
group by 1, 2, 3
),
upgraded_labels as (
select
case
when validator_type is null and node_id in ('e52cbcd825e328acac8db6bcbdcbb6e7724862c8b89b09d85edccf41ff9981eb'
,'2b396b7fab0102f104a2af7e095b145cc14da28f863564802e158afc3e07e638'
,'6c6af0933b710655ec553f4bead3b01c5e0a3ffd1194ee536efb926b356c54aa'
) then 'execution'
when validator_type is null and node_id in ('129aab6407f6f66774ce77a03b8abd1ba67317eab1c70c5c6cdd7a433a7d64e8'
,'1408c08272beb24ad4fe4e531a9b937a26ee72c5f56b50ac8f2b889c3c42d316'
,'48ba5aabeaf1a7c1bc6a96b20c8e9f6cbe7f6b3c77faec3b77fa66a630abf8c7'
Run a query to Download Data