Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi team, In Prefect Orion, how to specific postgres connection url with specific schema (instead of using public)? I am trying to use postgres instead of SQLite.

Hi Xavier, have you seen <https://orion-docs.prefect.io/concepts/database/#configuring-a-postgresql-database|this> page?

Kevin, I did. But it doesn't have info about how to specify the schema name in the connection URL.

We don’t design to give our schemas prefect-prefixed names to guarantee against collision with other schemas,  because we don’t develop anticipating overlapping databases.

You could change the default schema for the db user you’re using for Orion, on the postgres side with:
`ALTER USER my_user WITH DEFAULT_SCHEMA = OtherSchema;`

Note this is not recommended because it may cause future issues

Alter user works for me. But I can't create new user for every environment. Choosing different schema is the right way to address this issue.

Our recommendation here is for things to be separated by different databases (on the same pg server)