Unable to connect Chartbrew to Cube SQL API

[fabricebaranski]

Error when trying to connect Chartbrew to Cube SQL API

I've tried to connect cube.js with Chartbrew (https://chartbrew.com/) using SQL API, but I obtain the following error :

Unable to parse: ParserError("Expected equals sign or TO, found: ZONE")
QUERY: SET client_min_messages TO warning;SET TIME ZONE INTERVAL '+00:00' HOUR TO MINUTE;

It seems that Charbrew uses Sequelize to connect to a PostgreSQL DB.

[gandronchik]

Hello @fbvdka . Chartbrew has not supported by CubeSQL yet. We added it to backlog and I will notify you when it is supported.

[igorlukanin]

I've tested Chartbrew with the latest (v0.36.2) version of Cube with the query pushdown turned on.

I see that Chartbrew runs the following queries:

SET
  client_min_messages TO warning;
SET
  TIME ZONE INTERVAL '+00:00' HOUR TO MINUTE;

Cube responds with an error: Unable to parse: ParserError("Expected equals sign or TO, found: ZONE").

It looks like Cube needs to implement SET TIME ZONE queries: https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES