[__tobals__]

Yes, we looked at many different tools for inspiration and Trifacta was among them.

For join in action, you can watch this video: https://www.youtube.com/watch?v=r59Q19oCMr8&t=3s

We also support pivot and melt. About union: what do you have in mind here?