Home

NB. This project is no longer maintained. It has moved here

Welcome to Cardano on BigQuery

Access the project on Google's BigQuery: iog-data-analytics.cardano-mainnet

This project has been arising from the needs to analyse on-chain data from Cardano's blockchain. We run Db-sync to map the blockchain data to a relational model in PostgreSQL. Every n hours (currently: two hours) we export and update these data on BigQuery via a defined Update process.

The state of the data can be inspected through its dashboard🔗.

After every epoch, Data validation is run on the completed epoch and the data compared between BigQuery and PostgreSQL. The results of these comparisons are kept in a table and can be inspected through this dashboard🔗.