Tezos adoption is increasing globally via Google BigQuery integration
By Inkarias - 2020-10-15
Tezos officially announced the newest major news regarding the evolution of the project in our daily lives and furthermore the increasing adoption drove by several partnerships with worldwidely known entities. BigQuery, held by Google Cloud as a public dataset under ‘Financial services’, has been listed in the Google Cloud Marketplace. Google Cloud graciously hosts the dataset for public access where users pay only for the queries that they perform on the data. However, you can query this dataset for free, up to 1TB per month and most importantly every month!
What is Google BigQuery
Google BigQuery makes it simple to query on-chain data in a simple, organized manner on the cloud using standard SQL syntax. You can think of it like a massive indexer that allows you to perform powerful data analysis. You are also able to perform the same or similar queries on multiple blockchains at once and compare them, or track inter-chain activity on interoperable tokens such as TzBTC. The Tezos data needs to be loaded into a data warehouse to derive business relevant insights. This solution offer various possibilities and is not limited to :
Monitor gas costs over time, smart contract’s calls and activity
Map to a double-entry book data structure that enables multi-chain meta-analyses
Integration with conventional financial record processing systems
Determine the most active/popular tokens, contracts, or applications on Tezos
Query all transactions that adhere to specific conditions
A query to get the total amount of transactions ever executed on the Tezos blockchain would be as simple as this:
“ SELECT COUNT(*) as count
Tezos Commons currently loads Tezos data into BigQuery daily, via new Tezos ETL (Extract, Transform, Load) tools, Airflow DAGs, and a Kubernetes node. All of which are open source and publicly available.
More details on this implementation at https://tezos.com/