LittlerDataValidator Flow Stacked
    Updated 2023-04-22

    --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