cube-js / cube-js/cube

Unable to connect to Cube SQL API from another Cube instance

Open
#7,995 7 comments 5 reactions 0 assignees View on GitHub
api:sql
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
```
![image](https://github.com/cube-js/cube/assets/5620097/cca15be4-81f9-4473-8ae8-d6b95e623d5a)

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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.