search

dewi-alliance / dewi-etl

Publicly available Helium blockchain data - https://etl.dewi.org
MIT License
9 stars 1 forks source link

Revisit `transactions_exploded` as a generic way to de-JSONify transactions #16

Open jamiew opened 3 years ago

jamiew commented 3 years ago

This view isn't in the helium-etl-queries repo but is referenced by a number of queries

Could we just extract every possible JSON field into a column using this table? There is a limited # of fields, so it could even be hardcoded

Would be useful having indexes for many columns as well... e.g. payer/payee for payments