Introducing Google BigQuery: The New Solution Powered By Ethereum’s Blockchain

Meet Google BigQuery – a whole new big data platform and a warehousing solution that uses the Ethereum dataset available to enable the exploration of smart contract analysis. This is how Google introduced the BigQuery platform in a blog post.

Meanwhile, BigQuery is important because it uses all of Ethereum’s historical data. Also, Ethereum’s ETL project on GitHub has a source code which can be extracted from the blockchain and entered into BigQuery. Right now, it seems like Google is seeking new contributors and blockchains.

However, the real reason why Google tapped Ethereum’s blockchain is the following…

The digital giant wants to make the Ethereum blockchain data accessible on Google Cloud and stored in an easy way. Even though 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 of the data stored on the blockchain.

Luckily, BigQuery’s OLAP features are here to help. As they display a chart showing Ether transfers and transaction cost a year to date. According to them, tasks like prioritizing changes in the Ethereum architecture can add up and be synchronized in the Ethereum blockchain.

Google’s BigQuery can also sync the Ethereum blockchain to computers equipped with Parity (an Ethereum client for building applications) as well as extract data daily from the Ethereum blockchain ledger (including token transfers). The BigQuery Python library allows clients to query data tables in Kernels – which is a free in-browser coding platform on the public data science platform named Kaggle.

With this, Google’s BigQuery has demonstrated that it can identify the most used smart contracts based on transactions. Right now, the smart contract for the CryptoKitties game is the most popular out there. The platform can also measure tokens by different coefficients or by time window such as the daily number of token transfers of a specific token, with full visualization for the time period selected.