How does a new Dagster deployment initialize the schema and tables of its database? Is it automatic or manual?

[dagsir[bot]]

i have dagster deployed via docker. the postgres database the application needs for run, schedule and event_log storage is hosted in a separate docker container (pretty much the exact setup in the dagster docs). i'd like to move this database into an RDS solution hosted on AWS. once i have the new database up-and-running, will i need to actually create the schema and tables for the application to write into? or will it create them automatically once i update the instance's database connection? i don't care about preserving history from the docker container.

---

The question was originally asked in Dagster Slack.

[gibsondan]

Dagster will automatically initialize the schema and tables in RDS the first time either the daemon or the webserver start up.

[kaush-13]

do you know if there is a way to specify the schema if you want to use something other than public?

[vergenzt]

FYI @kaush-13 as far as I know there's not currently a way to specify a different schema. I've made a feature request here though which you can upvote! #25312