Unable to connect to Cube SQL API from another Cube instance
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
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
Contributor guide
Assessment
This issue has not been assessed yet.