cube-js/cube

Postgres connection - add option to set user "role"

Open

#8,530 opened on 2024年7月30日

GitHub で見る
 (2 comments) (0 reactions) (0 assignees)Rust (19,563 stars) (1,965 forks)batch import
data source driverdriver:postgreshelp wanted

説明

Is your feature request related to a problem? Please describe. I am trying to connect my Postgres instance to Cube Core - however our instance is set in a way where in addition to providing Username and Password we also need to provide a user role (https://www.postgresql.org/docs/current/sql-set-role.html)

Based on my research seems like Cube currently does not support this.

It would be great if we could support this as an optional configuration option just like dbt (https://docs.getdbt.com/docs/core/connect-data-platform/postgres-setup)

Describe the solution you'd like It would be great if we could have an environment variable to set user role, just like the ones we have for username and password. Also, @igorlukanin suggested another option on slack that - we could achieve this via "initSql" config option, just like for it is done in DuckDB https://github.com/cube-js/cube/blob/34d319a8d81744bde1e655fefeb23496f2fe1089/packages/cubejs-duckdb-driver/src/DuckDBDriver.ts#L163-L173

Thanks

コントリビューターガイド

技術スタック
postgresqlnodejs
領域
backenddatabase
Issue 種別
feature
難度新しい貢献者にとっての実装難度です。1 は非常に小さな変更、5 は専門的な作業です。
3
推定時間経験ある貢献者が調査、実装、テスト、pull request 準備にかけるおおよその時間範囲です。
half day
活動状況Issue が今どれだけ取り組みやすいかを示します。新しい、活発、古い、ブロック中、またはメンテナー入力待ちなどです。
fresh
明確さ期待される変更、受け入れ条件、次の手順がどれだけ明確かを示します。
mostly clear
前提条件
Basic understanding of Postgres connection settingsFamiliarity with Cube's driver architecture
初心者向け度初回貢献者にどれだけ取り組みやすいかを 1-100 で推定したスコアです。
60
調査方針
The issue requests adding an optional 'role' configuration for Postgres connections. A possible approach is to introduce an environment variable (e.g., CUBEJS DB ROLE) similar to existing username/password variables, or to implement it via the 'initSql' option as done for DuckDB in packages/cubejs duckdb driver/src/DuckDBDriver.ts (lines 163-173). To proceed, examine the Postgres driver code (likely in packages/cubejs postgres driver) to understand how connection parameters are passed, and then add the role parameter to the connection configuration. The maintainer suggested the initSql route, so that might be the simpler path. No linked PRs or assignees indicate this is open for contribution.
Postgres connection - add option to set user "role" · cube-js/cube#8530 | Good First Issue