Solved: Public Solana BigQuery Dataset (crypto_solana_main...

dani___

Hi 🙂
I’m using the BigQuery public dataset bigquery-public-data.crypto_solana_mainnet_us.transactions, and I’ve noticed that it hasn’t been updated since March 31, 2025, 17:42:02 UTC, despite the dataset showing a recent “Last modified” timestamp (April 2, 2025).

Here’s a quick query I used to verify:

SELECT MAX(block_timestamp) AS latest_ts
FROM bigquery-public-data.crypto_solana_mainnet_us.transactions
WHERE block_timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 48 HOUR)

Result:
latest_ts = 2025-03-31 17:42:02 UTC

This dataset is critical for real-time analytics on Solana activity. Could you please confirm:

1.Whether this is a known ingestion delay or an issue with the pipeline?

2.When the dataset is expected to resume regular updates?

Happy to provide more details if needed.
Thanks in advance for the support!

ruthseki

Hi @dani___,

Welcome to Google Cloud Community!

I understand that the last modified timestamp of the BigQuery dataset indicates recent activity, but the actual data within the transactions table hasn't been updated since March 31, 2025, 17:42:02 UTC.

Looking at the Google Cloud Status Dashboard, I’m not showing any reported incidents related to BigQuery or data ingestion pipelines. Feel free to double check it from your end as well.

In terms of dataset update, I found a similar case that you may find useful.

Also, I recommend contacting Google Cloud Support directly. Be sure to provide the following information in your support request:

The BigQuery dataset name
The specific issue
The query you used to verify the data lag
The impact on your analytics: Explain that this dataset is critical for real-time analytics.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

View solution in original post

ruthseki