GitHub user pankajduplo created a discussion: Allow warehouse database values
to be passed as a parameter DB_NAME in warehouse-util service
We are currently working on client portal developer pipeline. Whenever a
developer triggers a pipeline, a separate environment will be created for
him/her. As we will be using a shared cloud SQL, we are creating a separate
warehouse databases called "warehouse_<developer_environment_name>".
Similarly client portal and warehouse services also should be able to use
unique warehouse databases per environment.
However currently client portal and warehouse services are using hardcoded
database name called "warehouse", which is causing below error when we try to
create a warehouse from client portal UI:
``` File
"/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py",
line 508, in _handle_exception
self._adapt_connection._handle_exception(error)
File
"/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py",
line 792, in _handle_exception
raise translated_error from error
sqlalchemy.exc.ProgrammingError:
(sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class
'asyncpg.exceptions.UndefinedTableError'>: relation "warehouse" does not exist
[SQL: SELECT warehouse.id, warehouse.name, warehouse.status,
warehouse.instancetype, warehouse.version, warehouse.started_at,
warehouse.stopped_at, warehouse.deleted_at, warehouse.deleted_by_fk,
warehouse.endpoint, warehouse.resource_metadata, warehouse.last_heartbeat,
warehouse.created_by_fk, warehouse.created_on, warehouse.changed_by_fk,
warehouse.changed_on
FROM warehouse
WHERE warehouse.name = $1::VARCHAR AND warehouse.deleted_at IS NULL]
[parameters: ('Warehouse-CentaurusA-rn',)]
(Background on this error at: https://sqlalche.me/e/20/f405)```
Can you please fix this issue?
GitHub link: https://github.com/apache/superset/discussions/36941
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
