Login to Lambda BI

https://lambda-demo.p2p.org/

Choose data source

We will use

• DATABASE: Lambda GCP
• SCHEMA: raw_neutron
• TABLES:
  • events
  • messages
  • transactions

1st approach SQL

1st approach is about get all smart contract calls, even when particular SC called though another. That is why we will use raw_neutron.events table as a source

1. get contract addresses from JSON field (’_contract_address’)
2. choose raws with not null contract
3. get contracts we need
4. join with raw_neutron.transactions to get gas
5. prepare dataset “before” with 1 month before update (2024-02-28T19:15:10). We choose 1 month to make number of raws the same as dataset “after”
6. prepare dataset “after”
7. calculate AVG(gas_used) and number of transactions for dataset “before”
8. do the same for dataset “after”