A collection of SQL queries used to enrich data produced by a Helium blockchain-etl
This repo is specifically trying to create and manage views that better surface the embedded JSON fields in a
more managable form, e.g. turning transactions[type='state_channel_close'] => data_credits table, with properly typed columns
A live instance with these views is avaialble on the beta DeWi ETL instance, which runs Metabase:
If you're interested in using it, please contact @jamiedubs/@wishplorer on Discord. There is auto # available if using gmail.com email address with google signin.
Documentation available on: https://dbdocs.io/wishplorer/HeliumDewiETL
- setup a blockchain-etl instance – this might take a while
- load all the views from this repository:
dbname="etl"
for i in views/*; do psql $dbname < $i; done
Or load them one at a time etc.
- More views:
challenges,consensus_groups,payments, split out reward-types, etc - Get fancy and use dbt
- Pull requests welcome
- Ask questions in #hips or #blockchain-dev on Discord
- @~zav~
- @jamiedubs (@jamiew)
- @wishplorer
- @GregKarabinos
MIT