Unable to connect to Cube SQL API from another Cube instance

[zcpp]

While connecting to a Cube SQL API from another Cube instance, there will be a connection error:

Error while loading DB schema
error: Unable to parse: ParserError("Expected equals sign or TO, found: ZONE") QUERY: SET TIME ZONE 'UTC' at Parser.parseErrorMessage

To Reproduce Steps to reproduce the behavior:

1. Start cube instance A connects to a database and create some models. A is hosting in Server 1 with exporting PG port 10001;
2. Start another cube instance B in Server 2 and connects to SQL API of cube instance A as a PG datasource (with connecting to Svr1's port 10001).

Expected behavior Connect successfully and the data measures/schema from A can be loaded for creating model in B.

May be related to #5512

[lyndon-wu]

I've got the same issue...

[xuming0209]

Same error while I'm doing so

[zcpp]

as a workaround, I can temporarily comment out these 2 lines:

[paveltiunov]

@zcpp Could you please elaborate on your use case?

[zcpp]

@paveltiunov I am testing the possibility of cube in a crossing team scenario. Imagine a scenario where there are several data silos controlled by different teams within an organization, and they are unwilling or unable to directly share data sources. For some data or metrics needed by the upper level, they use cube to provide filtered or calculated data definitions separately. The upper level needs to use the models they provide as data sources for higher-level data analysis or aggregation. While the upper level also uses cube, this becomes my use case.

[igorlukanin]

@zcpp Did you consider allowing "lower level" teams to contribute to a single repository of Cube data models with multiple connected data sources? I believe it would significantly simplify the complexity of the setup.

[zcpp]

@igorlukanin Thank you for your suggestion, this could be a good approach. However, as you know, there is often an organizational issue. Trying to convince different organizations to hand over their data sources can be complex, and they will also be concerned about who will own this central cube.