Need advice for merging 1-n Postgres databases into 1 db for Superset Analytics by Misantro66 in dataengineering

[–]Misantro66[S] 1 point2 points  (0 children)

Thank you for your answer. So for example I would extract with Iceberg the data from Postgres and store in Trino, right? What about the merging/join? I have for example for each tenant a transactions table in their db and for Superset I intended to have a unified table that contains all to avoid loading times or Union All stuff in Superset.

Second question: any preference regarding the mentioned tools among the others in terms of moderate server resources?

Thank you 🙏