Create Metrics Charts
Publish your dashboard
How to Query Blockchain Data
There are thousands of dapps running on the Ethereum network. Their backend logic and data are stored and executed in the blockchain.
Decentralized applications running on Ethereum network
Who owns the data?
No one but everyone can access the data.
How does anyone get access to the data?
Every (archive) node in the Ethereum network contains a complete copy of the blockchain data. All we have to do is download and run the Ethereum client. The entire blockchain data would be downloaded to the machine.
Although this gives us access to the data, the raw data is not stored in a format suitable for analytical queries. We would have to extract data from the node, transform it, and then load it in a queryable format.
Blockchain-ETL is a set of open source scripts that allow us to transform and load data into a relational database so that we can query it using SQL.
DIY blockchain data hosting
Although the above option is ideal for anyone who wants to host their own blockchain database, it is the hardest to get started since it requires
🥱 Setting up and maintaining an archive node.
😫 Managing the ETL process and the database service.
There are providers who take away the complexity of the above process and allow us to query data directly using SQL or GraphQL.
Blockchain data providers
📘 Let's do a quick recap!
Which of the following tools allows us to query blockchain data using SQL?
Hint: check above diagram