Google Cloud is broadening its blockchain analytics platform. Having released Bitcoin's blockchain data for public examination on its infrastructure during the first half of 2018, the company
Google Cloud is broadening its blockchain analytics platform. Having released Bitcoin's blockchain data for public examination on its infrastructure during the first half of 2018, the company has now made Ethereum's transaction history queryable through BigQuery, its enterprise analytics service for processing enormous datasets.
BigQuery operates as a RESTful interface enabling interactive exploration of massive information repositories. Ethereum represents an advancement of Bitcoin's foundational architecture. Its creator, Vitalik Buterin, enhanced Bitcoin's original framework by introducing a processing engine capable of executing arbitrary instructions stored within the ledger—known as smart contracts.
Structurally, Ethereum mirrors Bitcoin in many ways. Both networks fundamentally document transactions immutably. However, they diverge substantially in data composition and transfer mechanisms. Both function as OLTP systems focused on transaction recording rather than analytical queries—a strength of OLAP platforms. Google observes that Ethereum's value transfers are straightforward and direct, while Bitcoin's approach is considerably more intricate. Additionally, Ethereum's design permits multiple smart contracts coordinating together to establish decentralized autonomous organizations, or DAOs.
While Ethereum's peer-to-peer software exposes certain APIs for limited functions like checking balances, it lacks comprehensive infrastructure for aggregate blockchain analysis or querying historical patterns across the entire network. This gap is where Google's solution becomes essential. As the company notes: "BigQuery has strong OLAP capabilities to support this type of analysis, ad-hoc and in general, without requiring additional API implementation." Google has constructed a cloud-based system that continuously replicates the Ethereum blockchain to servers running visualization tools. This setup, combined with its querying database, serves tactical purposes—determining network capacity and upgrade requirements, or evaluating wallet rebalancing speeds.
Google Cloud executes a daily synchronization process, pulling data directly from the Ethereum ledger. This extraction captures smart contract execution results, including token transfers. The information is then restructured, organized by date, and stored in BigQuery, enabling cost-efficient and accessible analysis.
Moving forward, Google intends to invite additional contributors and expand blockchain support across its platform.
