Xavier Babu

09/23/2022, 11:31 PM
Dear Prefect Community, is there any fix available to use a specific Postgres schema for Prefect Orion DB? Thanks, Xavier

Matt Conger

09/23/2022, 11:39 PM
Hi Xavier, I think this attached thread might assist with your question.

Xavier Babu

09/24/2022, 2:36 PM
Matt, I use that search_path workaround (recommended in that thread) for the last 4 months. The problem is, for every new environment, I have to create a new db user and assign a search_path. That is not a good approach. If we can support schema configuration in the Profiles.toml itself, that would be great.