https://prefect.io logo
t

Tom

07/21/2023, 11:29 AM
Hey all, is it possible to specify a schema for the db migrations of a self hosted Prefect instance?
d

Deceivious

07/21/2023, 1:40 PM
Why not have a migration py file that starts prefect server , migrates , shuts it down and then runs your alter queries against the database?
t

Tom

07/21/2023, 1:43 PM
well, I have an existing database, so I want to include the tables generated for Prefect to be isolated in its own schema
d

Deceivious

07/21/2023, 1:53 PM
Oh i didnt read correctly. I dont think its possible. I am not sure but i think Prefect uses sql alchemy under the hood and you cant specify schema in sql alchemy connection string.
t

Tom

07/21/2023, 1:54 PM
ah ok, too bad, I guess I have to get another DB for prefect then