Google Cloud Integrates 11 New Blockchains into BigQuery Data Warehouse

BigQuery: A Data Warehouse Powerhouse
Enhancing Blockchain Queries with User-Defined Functions (UDFs)
Google Cloud’s Growing Interest in Blockchain
FAQ

Google Cloud has taken a significant step in embracing blockchain technology by expanding its BigQuery data warehouse to support 11 additional blockchain networks. This move extends the capabilities of BigQuery, allowing users to access a wealth of data from various blockchain networks and reaffirming Google’s commitment to blockchain technology in data analysis.

BigQuery: A Data Warehouse Powerhouse

BigQuery, Google’s renowned data warehouse service, provides enterprises with a powerful platform for efficient data storage and querying. While originally designed for private data storage, BigQuery also offers access to an array of public data sets that users can query to derive valuable insights. These data sets encompass a wide spectrum of information, including Google Trends data, American Community Service demographic information, Google Analytics metrics, and much more.

Google’s journey into blockchain data integration began in 2018 when it introduced a Bitcoin data set as part of its BigQuery service. Later that year, Ethereum data was incorporated. The company continued to expand its support for blockchain data in February 2019 by adding data sets for Bitcoin Cash, Dash, Dogecoin, Ethereum Classic, Litecoin, and Zcash. With the latest announcement on September 21, Google Cloud has now extended its blockchain support to encompass a total of 19 different blockchain networks.

We're enhancing our #blockchain data offering with 11 new chains in #BigQuery, and we’re also making improvements to our existing datasets, so they are more precise, accurate, and reliable.

Learn more ↓https://t.co/fNFJiHSJBO
— Google Cloud (@googlecloud) September 21, 2023

Enhancing Blockchain Queries with User-Defined Functions (UDFs)

In addition to the inclusion of new blockchain networks, Google has introduced a valuable feature aimed at simplifying blockchain queries. The development team has implemented user-defined functions (UDFs) designed to handle the often complex long-form decimal results frequently encountered in blockchain data. These UDFs are expected to provide users with access to extended decimal precision for their blockchain data, minimizing the risk of rounding errors during computational processes.

Google Cloud’s Growing Interest in Blockchain

Throughout 2023, Google Cloud has displayed a growing interest in blockchain technology and its diverse applications. On July 7, the company forged a partnership with Voltage, a prominent Lightning Network infrastructure provider, to explore Lightning Network solutions. More recently, on September 14, Google Cloud collaborated with the Web3 startup Orderly Network to contribute off-chain components for decentralized finance (DeFi) initiatives.

This continuous expansion of blockchain support within BigQuery reflects the increasing importance of blockchain technology in both data analysis and enterprise operations. As the blockchain ecosystem continues to evolve, Google’s dedication to delivering accessible and accurate blockchain data through BigQuery solidifies its position as a central figure in the integration of blockchain technology into data analysis.

FAQ

1. What is BigQuery, and how does it relate to Google Cloud?

BigQuery is Google’s data warehouse service, part of the Google Cloud platform, which enables enterprises to efficiently store and query their data, including access to both private and public data sets for analysis.

2. How many blockchain networks are now supported by Google’s BigQuery?

Google’s BigQuery now supports data from a total of 19 blockchain networks, including well-known networks such as Bitcoin, Ethereum, Bitcoin Cash, Dash, Dogecoin, Ethereum Classic, Litecoin, Zcash, and 11 additional networks recently integrated.

3. What is the purpose of the user-defined functions (UDFs) introduced by Google in BigQuery for blockchain data?

The UDFs introduced in BigQuery are designed to simplify the handling of long-form decimal results commonly encountered in blockchain data. They offer extended decimal precision, reducing the potential for rounding errors in complex computations.

4. How has Google Cloud been involved in blockchain technology in 2023?

In 2023, Google Cloud has demonstrated a growing interest in blockchain technology through partnerships with Voltage, a Lightning Network infrastructure provider, and collaboration with Web3 startup Orderly Network to contribute to decentralized finance (DeFi) projects