Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

rollupJoins on multiple DBs of different types #3432

Open
ryanpei opened this issue Sep 15, 2021 · 0 comments
Open

rollupJoins on multiple DBs of different types #3432

ryanpei opened this issue Sep 15, 2021 · 0 comments
Labels
enhancement New feature proposal

Comments

@ryanpei
Copy link
Contributor

ryanpei commented Sep 15, 2021

Is your feature request related to a problem? Please describe.
When performing a rollupJoin on two different databases, this is not possible supported with different DB types, such as Mongo and Snowflake. In other cases it can still work but perform slowly.

Describe the solution you'd like
Cube Store can do a rollupJoin on databases from two different DB types.

Describe alternatives you've considered
Consolidating all my data on one DB, instead of using multiple data sources. This requires migration/ETL work on my end, though. I could also set up external pre-aggregations, but this adds complexity and then I can't use the optimizations of Cube Store here.

Additional context
We also discussed this in Slack per https://cube-js.slack.com/archives/CC0403RRR/p1630176403090300

@paveltiunov paveltiunov added the enhancement New feature proposal label Sep 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature proposal
Projects
None yet
Development

No branches or pull requests

2 participants