berachain-models/models/streamline/_block_lookback.sql
2024-07-08 11:18:38 -06:00

12 lines
294 B
SQL

{{ config (
materialized = "ephemeral"
) }}
SELECT
MIN(block_number) AS block_number
FROM
{{ ref("silver_testnet__blocks") }}
WHERE
block_timestamp >= DATEADD('hour', -72, TRUNCATE(SYSDATE(), 'HOUR'))
AND block_timestamp < DATEADD('hour', -71, TRUNCATE(SYSDATE(), 'HOUR'))