Metabase + Cube : Can it help in multiple data source combining issue?

Please check this link Introducing Data Blending API in Cube - Cube Blog

Can it solve the Feature: Join across multiple databases · Issue #3953 · metabase/metabase · GitHub ?

Thanks in advance !

there are several ways of solving #3953: Cube, Trino/Presto, foreign data wrappers

1 Like

This seems to work if I had to query directly
but I would want to use trino & dump results in another db (say db3)
and create model in metabase for that new table

But I want the db3 population query to be called thrice a day
I dont need model caching in metabase, Metabase can call that db directly for model.

I would do all that programmatically via en elt

1 Like