• Google LLC adds Ethereum Blockchain to its big data analytics platform BigQuery.
• The new service “de-normalizes and stores date-partitioned data to BigQuery for easy and cost-effective exploration.”

It has been announced that Google LLC, the well-known tech company that offers Internet-related services and products, such as online search engine, online advertising technologies, software, cloud computing, and hardware, has added Ethereum to its big data analytics platform “BigQuery.”

 

Google released the announcement on Saturday 1st September 2018 in a blog post. According to the blog post, Google revealed that though there is an application programming interface (API) in existence that is used for common functions like checking wallet balances and transaction status, accessing all the data stored on the on the Ethereum blockchain is not very easy.

It was further revealed by the post that the existing API does not support the viewing of blockchain data “in aggregate.”

 

According to Google, the new service aims at providing more of a Big Data window into Ethereum:

“A visualization like this … is useful for making business decisions, such as prioritizing improvements to the Ethereum architecture itself (is the system running close to capacity and due for an upgrade?) to balance sheet adjustments (how quickly can a wallet be rebalanced?).”

 

Google has built the software system on its Cloud platform, and the system is capable of carrying out several things such as: “synchronizing the Ethereum blockchain to computers running Parity; pulling data from the Ethereum blockchain on a daily basis, including the results of smart contract transactions; and de-normalizing and storing date-partitioned data to BigQuery for easy and cost-effective exploration.”

Google presented some examples of why the addition of Ethereum to its BigQuery may be useful/interesting to users. For instance, CryptoKitties smart contract transactions are the largest on the Ethereum network. Furthermore, the software system adds a visualization for “pedigrees” of accounts that have above 10 CryptoKitties:

 

The post added that data from the bitcoin network was added to Big Data Analytics Platform earlier this year. Those who are interested in trying out Google’s new software system can already query Ethereum’s data in Kaggle.