Hi, I'm using dagster 1.3.11 with dagster_postgres for eventlog storage. The configuration in 'dagster.yaml' accommodates parameters 'username', 'password', 'hostname', 'db_name', 'port'

storage:

postgres:

postgres_db:

username: {"env": "X"}

password: {"env": "X"}

hostname: {"env": "X"}

db_name: {"env": "X"}

port: {"env": "X"}

There does not seem to be a way to tell it which schema in the database to use. It defaults to the public schema however i'd like the logging to go into another schema. Is this possible? Cheers, Ian

it can be done via the params config section

params:
              options: -c search_path=other_schema

Thanks Alex, this works. Is it possible to set the schema from a defined environment variable? Does'nt seem to work as the dagster yml schema does not seem to allow this.

ya agree with your assessment - feel free to file an issue requesting that feature

@Ian Venter hope you don't mind, came up against the same issue today, raised an issue as described here: https://github.com/dagster-io/dagster/issues/15508

Thanks for raising the github ticket @Andy Carter. @sandy, being able to fully parameterize dagster deployments is important at enterprise scale. I'm hoping this issue can get some priority.