aleo-models/models/streamline/streamline__blocks.sql

{{ config (
    materialized = "table",
    tags = ['streamline_view']
) }}

SELECT
    _id AS block_number
FROM
    {{ source(
        'crosschain_silver',
        'number_sequence'
    ) }}
WHERE
    _id <= (
        SELECT
            MAX(block_number)
        FROM
            {{ ref('streamline__chainhead') }}
    )
UNION ALL
SELECT
    0