Show HN: Graphical ETL Based on JSONata

Posted by aeberhart on Wednesday July 14, 2021 @03:06PM
from the show-hn dept.

https://www.youtube.com/watch?v=ZsjyucALidY

( 3 comments | 3 points | on HN )

Re:Show HN: Graphical ETL Based on JSONata by aeberhart on Wednesday July 14, 2021 @03:06PM (#27837045)

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

[ Parent | on HN ]

Re:Show HN: Graphical ETL Based on JSONata by alexmE01 on Wednesday July 14, 2021 @03:53PM (#27837630)

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

[ Parent | on HN ]

Re:Show HN: Graphical ETL Based on JSONata by aeberhart on Wednesday July 14, 2021 @04:06PM (#27837772)

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.

[ Parent | on HN ]