Hacker News new | ask | show | jobs
Show HN: Graphical ETL Based on JSONata (youtube.com)
3 points by aeberhart 1798 days ago
2 comments

Dashjoin is an open source platform that allows you to easily extract, load, and transform (ETL) data into a database of your choice. We use JSONata, a powerful JSON query and mapping language, in conjunction with a graphical mapping editor for this task. The platform also allows you to visualize and query the resulting data in the database.

Would love to hear your feedback! Github: https://github.com/dashjoin/platform

Cool Demo! Is the $doc2data a standard jsonata feature?
Thanks! No, $doc2data is not a standard function. JSONata allows you to define your own functions (https://docs.jsonata.org/embedding-extending#expressionregis...). JSONata is great for transformation and we added functions for loading data.