Google Cloud Expands BigQuery to Include 11 Additional Blockchains for Web3 Analytics

By Tsunami 09/22/23 3:25 PM

In a major stride towards enhancing Web3 analytics and blockchain accessibility, Google Cloud has expanded its BigQuery public data sets with the addition of 11 highly sought-after blockchains. This development marks a significant milestone in the tech giant’s ongoing efforts to democratize blockchain data and provide valuable insights to users worldwide.

Expanding the Blockchain Universe

As revealed in a recent Thursday blog post, Google Cloud users can now query data from a diverse set of blockchains, including Avalanche, Arbitrum, Cronos, Ethereum Goerli, Fantom, Near, Optimism, Polkadot, Polygon, Polygon Mumbai, and Tron. This expansion comes as a follow-up to Google Cloud’s initial venture into blockchain data democratization in 2018, followed by the inclusion of six additional datasets in 2019.

The motivation behind this move, as stated in the blog post, is to meet the growing demand from various stakeholders within the blockchain ecosystem, including blockchain foundations, Web3 analytics firms, partners, developers, and customers. They all seek a more comprehensive view of the crypto landscape and the ability to query multiple chains to answer complex questions.

These questions encompass topics such as the number of NFTs minted across specific chains, the comparison of transaction fees across different blockchains, and the count of active wallets on top EVM chains. With the inclusion of these 11 blockchains, the BigQuery public datasets are now better equipped to provide the answers, all without the overhead of operating nodes or maintaining an indexer.

Unlocking Valuable Insights

The addition of these blockchains to BigQuery offers users the ability to query full on-chain transaction history off-chain. This empowers them to understand the flow of assets between wallets, identify the most popular tokens, and gain insights into how users interact with smart contracts. It’s a significant step toward making blockchain data accessible and understandable for a broader audience.

Google’s Commitment to Quality Data

In addition to community-managed datasets, Google Cloud is introducing first-party Google Cloud managed datasets. These datasets offer advanced features and capabilities, ensuring that users can access rich, high-quality data for analysis. For example, Google has created a dedicated Ethereum dataset with curated tables for events, providing a full representation of the data model native to Ethereum.

Efficiency and Precision

Google Cloud has also taken user feedback into account to improve the precision of blockchain datasets. They have introduced User-Defined Functions (UDF) for UNIT256 integration and BIGNUMERIC1 support. This allows for longer decimal digits in blockchain data and reduces rounding errors during calculations. Such improvements are crucial for accurately calculating the pricing of cryptocurrencies.

Making Data More Accessible

One of the major challenges in blockchain data analysis is the need to access the right nodes and develop and maintain indexers for each protocol of interest. Google Cloud’s expertise in scalable data processing now simplifies this process. By making on-chain data accessible off-chain, developers can access blockchain data without the complexity of managing nodes.

This accessibility extends beyond developers, with end-user applications like Looker and Google Sheets benefiting from this data. Users across various domains can leverage this data to gain valuable insights and make informed decisions.

A Collaborative Future

Google Cloud’s commitment to the Web3 community is evident in its continuous efforts to expand its blockchain data offerings. The company is open to collaboration with partners, startups, and data providers to further enrich and distribute public data for developers and other stakeholders.

In conclusion, Google Cloud’s addition of 11 new blockchains to its BigQuery public datasets represents a significant leap forward for Web3 analytics and blockchain accessibility. This move aligns with Google’s commitment to democratizing data and providing users with the tools they need to navigate the ever-evolving blockchain landscape.

Read more:

Join us on Telegram