cube-js/cube

CUBEJS_DB_SCHEMA doesn't work for snowflake connector

开放

#7,285 创建于 2023年10月20日

 (1 条评论) (0 个反应) (0 位负责人)Rust (1,965 个派生)batch import
help wanted

仓库指标

星标
 (19,563 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

Describe the bug I am trying to load a schema with many millions of columns and it is taking long and failing. I tried using CUBEJS_DB_SCHEMA to filter the results, which I believe would work. Documented here: https://cube.dev/docs/reference/configuration/environment-variables#cubejs_db_schema

But this setting does not influence the information schema query. I can see that the info schema query is hardcoded and the env var is never templated in: https://github.com/cube-js/cube/blob/master/packages/cubejs-snowflake-driver/src/SnowflakeDriver.ts#L849

To Reproduce Steps to reproduce the behavior:

  1. Set the CUBEJS_DB_SCHEMA env var
  2. Connect via snowflake
  3. Observe that it runs the informationSchema query without filter

Expected behavior The informationSchema query should include the schema filter in the where clause.

Screenshots N/A

Minimally reproducible Cube Schema N/A

Version: 0.34.6

Additional context N/A

贡献者指南