An user mentioned that a transaction coudn't be found in the BQ dataset:
SELECT
*
FROM
bigquery-public-data.crypto_near_mainnet_us.receipt_actions ra
WHERE
ra.block_date = '2022-01-19'
and ra.receipt_id = 'FEkaV4fxRTCKNBswDVRacHAXLukAB6wq1r9cRey3jugd'
Skipped Blocks - NEAR Blockchain can contain skipped blocks, e.g. block 57730443. For these cases we can find the block for the chunk data using the prev_block_hash column, e.g. SELECT * FROM chunks c JOIN blocks b ON c.chunk.header.prev_block_hash = b.header.prev_hash.
eduohe
commented
2 months ago
An user mentioned that a transaction coudn't be found in the BQ dataset: SELECT * FROM bigquery-public-data.crypto_near_mainnet_us.receipt_actions ra WHERE ra.block_date = '2022-01-19' and ra.receipt_id = 'FEkaV4fxRTCKNBswDVRacHAXLukAB6wq1r9cRey3jugd'
https://nearblocks.io/txns/9ioLz3jJavEiiYVVVX2pDrPPQWXSL4zoH8o8uXzMTSSB#
Cause:
Skipped Blocks - NEAR Blockchain can contain skipped blocks, e.g. block 57730443. For these cases we can find the block for the chunk data using the prev_block_hash column, e.g. SELECT * FROM chunks c JOIN blocks b ON c.chunk.header.prev_block_hash = b.header.prev_hash.