Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
jamiew opened this issue Aug 9, 2021 · 0 comments
Open

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

jamiew opened this issue Aug 9, 2021 · 0 comments
Labels
analytics

Comments

@jamiew
Copy link
Contributor

jamiew commented Aug 9, 2021

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
analytics
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jamiew