DEV Community

Cover image for Blockchain Analytics: Exploring Ethereum Data with BigQuery, RAG, and AI
Gary Zavaleta
Gary Zavaleta

Posted on

Blockchain Analytics: Exploring Ethereum Data with BigQuery, RAG, and AI

Hey everyone!

Sharing my latest project, a Google BigQuery + Ethereum RAG pipeline that integrates machine learning and AI capabilities for on-chain data exploration.

The idea is to make Ethereum blockchain analytics more intelligent, by combining:

  • Google BigQuery’s Ethereum dataset
  • Retrieval-Augmented Generation (RAG)
  • LLM-assisted SQL generation and embeddings

It is designed for Blockchain Analytics developers, researchers, and data scientists who want to run natural language blockchain queries, detect anomalies, and even power AI-driven dashboards.

Check it out here: https://github.com/garyzava/bigq-ethereum-rag

Would love your feedback, suggestions, or collaboration ideas! Feel free to ⭐ the repo if you find it useful.

Top comments (1)

Collapse
 
roshan_sharma_7deae5e0742 profile image
roshan sharma

That’s awesome, man. Super cool idea combining BigQuery and RAG for Ethereum analytics, really smart move. Love how you’re bridging AI with on-chain data. Solid work, seriously.