Integration of 11 blockchains into Google Cloud's data warehouse, 'BigQuery'

Google Cloud’s BigQuery Adds 11 New Blockchains to Data Warehouse

Google Cloud’s BigQuery service has expanded its data warehouse by adding 11 new blockchain networks, according to a blog post on September 21. The newly added networks include Avalanche, Arbitrum, Cronos, Ethereum Görli testnet, Fantom, Near, Optimism, Polkadot, Polygon mainnet, Polygon Mumbai testnet, and Tron.

BigQuery: Google’s Data Warehouse Service

BigQuery is a data warehouse service offered by Google that allows enterprise firms to store and query their data. It provides various public datasets for querying purposes, such as Google Trends, American Community Service demographic information, and Google Analytics.

Expansion of Blockchain Coverage

In 2018, Google introduced a Bitcoin dataset on BigQuery and later added Ethereum to its offerings. In February 2019, it further expanded its blockchain coverage by including Bitcoin Cash, Dash, Dogecoin, Ethereum Classic, Litecoin, and Zcash. With the recent addition of 11 new blockchains, BigQuery now supports a total of 19 blockchain networks.

Easier Blockchain Queries with User-Defined Functions

In addition to the new blockchains, Google has implemented user-defined functions (UDFs) aimed at simplifying blockchain queries. These UDFs provide methods to handle long-form decimal results commonly found on blockchains. According to Google’s announcement, these functions offer customers access to longer decimal digits for their blockchain data and reduce rounding errors in computations.

Google Cloud’s Growing Interest in Blockchain Tech

Throughout 2023, Google Cloud has been increasingly involved in blockchain technology. It partnered with Voltage on July 7 to collaborate on Lightning Network infrastructure. On September 14, it teamed up with Web3 startup Orderly Network to support off-chain components for decentralized finance.

Hot Take: Google Cloud Expands Blockchain Data Offering with BigQuery

Google Cloud’s addition of 11 new blockchains to BigQuery’s data warehouse demonstrates its commitment to supporting blockchain technology. With an expanded range of blockchain networks available on the platform, users can access and analyze blockchain data more efficiently. The implementation of user-defined functions further enhances the querying process by handling long-form decimal results and reducing rounding errors. This move highlights Google Cloud’s growing interest in the blockchain sector, as evidenced by its recent partnerships in the Lightning Network and decentralized finance spaces. By embracing blockchain technology, Google Cloud is positioning itself as a key player in the evolving digital landscape.