marquBANX TGE - Data Freshness
    Updated 2024-03-29
    with

    block_info as (

    select

    block_id
    , block_timestamp
    , floor(datediff('minute',block_timestamp, current_timestamp()) / 60) as hours
    , mod(datediff('minute',block_timestamp, current_timestamp()), 60.0) as minutes
    , concat(iff(hours < 10, concat('0',hours::string), hours ::string)
    , ':'
    , iff(minutes < 10, concat('0',minutes::string), minutes ::string)
    ) as lag
    from solanaUpdate.core.fact_events
    where block_timestamp > current_date() - 1
    order by block_timestamp desc nulls last
    limit 1
    )

    select

    current_timestamp(0) as "Last Dashboard Refresh"
    , block_timestamp as "Last Block Timestamp Available"
    , lag as "Data Lag (HH:MM)"
    , block_id

    from block_info
    Last run: 21 days ago
    Last Dashboard Refresh
    Last Block Timestamp Available
    Data Lag (HH:MM)
    BLOCK_ID
    1
    2025-02-02 10:54:02.0002025-02-02 10:38:10.00000:16317972045
    1
    73B
    3s