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

Hello,
What postgress schema does prefect 2.0 use? Can we use different. Schema?

Hi Amol, is there an issue you are trying to solve with doing this?
Prefect 2 comes with SQLite by default and I think you can get the base schema from there, I’m not 100% sure if it’s openly shared, but I can try to find out

Amol, just to clarify: are you asking about the Postgres schema name Prefect uses?

Yes I like to know what schema name  prefect uses?

I am having issue as in setup we don't have public schema and we have to create one and use it.

I just tested and verified that Prefect 2 will use whichever schema is the default for the user you specify in the connection string (which you can change by altering the Postgres user's `search_path`).

But note that the Postgres schema you use will need to have the <https://www.postgresql.org/docs/current/pgtrgm.html|pg_trgm> extension added (or it needs to be added to another schema that is included in the user's `search_path`).