Google BigQuery, Google Cloud’s Petabyte-scale data warehousing solution, has made the Ethereum dataset available to enable the exploration of smart contract analytics, the company announced on a blog.
BigQuery has made it possible to explore all of Ethereum’s historical data. Ethereum’s ETL project on GitHub includes all source code that can be extracted from the blockchain and entered into BigQuery. Google is seeking new contributors and blockchains.
The purpose of making the Ethereum blockchain data accessible on Google Cloud is to make all data stored on the blockchain easily accessible. While Ethereum’s software contains APIs for functions that can be accessed randomly, such as checking wallet balances, the API endpoints are not easily accessible for all data stored on the blockchain.
While API endpoints do not enable viewing blockchain data in aggregate, BigQuery’s OLAP features enable such analysis. The blog displayed a chart showing Ether transfers and transaction costs year to date, aggregated by day. Such visualization supports tasks like prioritizing changes in the Ethereum architecture, should an upgrade be needed.