search

cube-js / cube

📊 Cube — Universal semantic layer platform for AI, BI, spreadsheets, and embedded analytics
https://cube.dev
Other
17.96k stars 1.78k forks source link

'undefined' in database http://localhost:4000/#/schema - can't see DB or Tables - Snowflake DB #8802

Closed mattssll closed 1 month ago

mattssll commented 1 month ago

Describe the bug When connecting to Snowflake DB via Cube in docker, I see "undefined", instead of DB name.

To Reproduce

Connect to snowflake DB, Check /schemas, seeing undefined in DB

Expected behavior I should be seeing the Database and its tables, not undefined. Screenshots

image

Version: Latest

Additional context Simply trying to connect to snowflake DB and having issues... I can see the query being made in SNOWFLAKE BACKEND:

SELECT COLUMNS.COLUMN_NAME as "column_name",
               COLUMNS.TABLE_NAME as "table_name",
               COLUMNS.TABLE_SCHEMA as "table_schema",
               CASE WHEN COLUMNS.NUMERIC_SCALE = 0 AND COLUMNS.DATA_TYPE = 'NUMBER' THEN 'int' ELSE COLUMNS.DATA_TYPE END as "data_type"
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE COLUMNS.TABLE_SCHEMA NOT IN ('INFORMATION_SCHEMA')

The query succeeds, but I still get the undefined in my UI

I believe a list is returned with 6 items of undefined

mattssll commented 1 month ago

Duplicate of https://github.com/cube-js/cube/issues/7440