is there any way to mention DB_Name for SQL API in cubejs?

cube-js / cube

📊 Cube — Universal semantic layer platform for AI, BI, spreadsheets, and embedded analytics

https://cube.dev

Other

17.97k stars 1.78k forks source link

is there any way to mention DB_Name for SQL API in cubejs? #6417

Open akhlaq-ha opened 1 year ago

akhlaq-ha commented 1 year ago

Problem

I am trying to connect SQL API via PostgreSQL OLEBD driver provided by Intellisoft in excel. The connection establishes successfully and I can see the tables list.

But when ever I try to connect specific table it shows the following error.

I am assuming that the path for the table is wrong since I cannot see any database names 'postgres' listed in pg-cli.

Is my assumption right? if so how can I provide database name in cubejs env file?

ovr commented 1 year ago

Hello @akhlaq-ha,

It's not supported now.

Thanks

akhlaq-ha commented 1 year ago

hello @ovr , same database name not found issue occurs when using ODBC DSN to connect. will it be resolved in the future? Thanks

ovr commented 1 year ago

will it be resolved in the future?

As I know we have a long-term plan to support popular tools/BIs with SQL API. I cannot provide ETA.

cC @paveltiunov

Thanks

hawkEye-01 commented 1 year ago

hello @ovr does this cubesql feature related to my issue?

Thanks

igorlukanin commented 1 month ago

@akhlaq-ha @hawkEye-01 Could you please check the latest version of Cube (v0.36.x) with the query pushdown turned on? Cube's SQL API has substantially improved over the last months/years.