Multiple DB_NAME (schemas) for the same datasource

[LidorPrototype]

Problem

I connected cube over docker-ompose and in it I set up trino as a datasource with catalog and CUBEJS_DB_NAME but my trino got multiple schemas but I cant seems to able to get them.

I tried setting CUBEJS_DATASOURCES to default and datasource1 and then using also the CUBEJS_DS_DATASOURCE1_<TYPE> accordingly but it still does not seem to get them when I open the web page, i see only the default one.

Right now my goal is to use that same trino host and catalog for multiple schemas it got (in the future I'll need to add more datasources outside of trino too).

I've searched the web and here in the issued too and found a couple that seems to be similar but the answer from there did not help (for example the one I mentioned above)

docker-compose file enviroments keys:

CUBEJS_DEV_MODE=true
CUBRJS_DB_USER=<actual user>
CUBEJS_DB_PASS=<actual pass>
CUBEJS_DB_PRESTO_CATALOG=<actual catalog>
CUBEJS_DATASOURCES=default,datasource1
CUBEJS_DB_TYPE=trino
CUBEJS_DB_HOST=<actual host>
CUBEJS_DB_PORT=443
CUBEJS_DB_NAME=<actual nanme 1>
CUBEJS_DATASOURCE1_DB_TYPE=trino
CUBEJS_DATASOURCE1_DB_HOST=<actual host>
CUBEJS_DATASOURCE1_DB_PORT=443
CUBEJS_DATASOURCE1_DB_NAME=<actual name 2>
CUBEJS_DB_SSL=true

And I only see the default one

[igorlukanin]

Hi @LidorPrototype 👋

my trino got multiple schemas but I cant seems to able to get them

it still does not seem to get them when I open the web page, i see only the default one

I think the issue is not (only) with the connection logic here. The issue is that, in Cube Core, the data model generation UI only shown tables from the default data source: https://cube.dev/docs/product/workspace/playground#cube-core

There's a workaround by the link above.

[LidorPrototype]

Thank you, that worked for locally, when I'll integrate it to not locally, it will show them all?
@igorlukanin