3 ms·
Is this capable of performing efficient JOINs across non-homogeneous data-stores?
by posix_monad 3y ago
Is this capable of performing efficient JOINs across non-homogeneous data-stores?
- Lucasoato 3y agoShould it? If you really need that, join the different sources with TrinoDB (or any related managed service like AWS Athena) and connect it to Superset.
- ildjarn 3y agoIt’s common for business questions to only be answerable with a join over a few different stores. I think Athena can only query data on S3?
- totalhack 3y agoSuperset would be on my shortlist if I had to use something else, but the join limitations were part of why I passed.
- grzaks 3y agoWe use https://cube.dev/ https://cube.dev/ as intermediate layer between data warehouse database and Superset (and other "terminal" apps for BI like report generators). You define your schema (metrics, dimensions, joins, calculated metrics etc) in cube and then access them by any tool that can connect to SQL db