Show HN: Graphical ETL Based on JSONata (youtube.com)

3 comments

[ 2.4 ms ] story [ 9.4 ms ] thread

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

alexmE01 5y ago ↗

Cool Demo! Is the $doc2data a standard jsonata feature?

aeberhart 5y ago ↗

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.