https://dagster.io/ logo
#ask-community
Title
# ask-community
i

Ian Venter

07/21/2023, 9:05 AM
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
a

alex

07/21/2023, 4:54 PM
it can be done via the params config section
Copy code
params:
              options: -c search_path=other_schema
👍🏿 1
👍 1
i

Ian Venter

07/22/2023, 4:55 AM
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.
a

alex

07/24/2023, 4:01 PM
ya agree with your assessment - feel free to file an issue requesting that feature
a

Andy Carter

07/25/2023, 2:57 PM
@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
🙌🏿 1
i

Ian Venter

07/25/2023, 11:07 PM
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.
2 Views