Google is not slowing down with the new blockchain technology. A few months after releasing Bitcoin support for its BigQuery database tool, Google launched a new plug-in to analyze the Ethereum ETH blockchain .
Google has provided users with a new new way to interact with Ethereum data. There are already services that show information on the addresses and transactions of the portfolio, but until now, investigating the full range of data stored on the blockchain has been a cumbersome process. BigQuery can also connect directly with the Parity client.
Chrome's regular users are now able to read all the data stored on the Ethereum blockchain. Take, for example, this new fantasy table. BigQuery can show us charts of all Ethereum transfers, including the cost of the transaction.
Charts such as these are more useful for making business decisions, including the development of the Ethereum architecture itself. With the new tool, check if the Etheruem system is running at full capacity and needs updates is made possible with a simple database query.
The Big G has also developed a new interface to display smart contracts. Google used the popular Ethereum dApp CryptoKitties as an example of how BigQuery can create interesting maps of Ethereum traffic.
Here is an overview of the CryptoKitties breeder's account that owns 10 or more digital cats; the size of the blobs indicates their reproductive power.
This is literally an overview of the pedigree of CryptoKitties. It's disturbing? I think it's creepy
Other cases of use are not so frivolous.
BigQuery can also provide us with clear views on token activity. Below, a chart shows us the data related to the transfers, in particular the ERC-20 OmiseGO token (OMG).
That big peak in blue activity corresponds to a recent flight in which a lot of OMG tokens have been received by many portfolios at the same time. We can assume that many users have retained the tokens they received, at least for that week.
Something completely new is the ability to compare smart contracts, especially in their functionality. The integration of Ethereum with BigQuery offers the freedom that comes from a vast suite of analytical tools.
The Ethereum data extracted from BigQuery is updated daily. To fully exploit its functionality, a practical knowledge of database programming is certainly useful, since all queries are executed using SQL.
Google is also preparing some other blockchain tools – announced earlier a new development kit that should provide customers with an easy way to create smart contracts and distribute decentralized applications.
Published September 3, 2018 – 11:20 UTC