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 !
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
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