Hello everyone, I'd like to have dagster save the event logs to a different schema within my postgres db. How would I do that in the

dagster.yaml

config? Specifically I'm looking for something like this:

yaml
event_log_storage:
  module: dagster_postgres.event_log
  class: PostgresEventLogStorage
  config:
    postgres_db:
      hostname: {hostname}
      username: {username}
      password: {password}
      db_name: {db_name}
      port: {port}
      schema: {myschema}

However there doesn't appear to be any mention in the supporting documentation that allows the connection to specify a schema. Does anyone have any suggestions on how to resolve this issue?

hey Denton, according to this GH Issue this is doable using this syntax:

event_log_storage:
  module: dagster_postgres.event_log
  class: PostgresEventLogStorage
  config:
    postgres_db:
      username: { username }
      password: { password }
      hostname: { hostname }
      db_name: { db_name }
      port: { port }
      params:
        options: -csearch_path={ schema_name }

much appreciated thank you!