Hey all, is it possible to specify a schema for the db migrations of a self hosted Prefect instance?

Why not have a migration py file that starts prefect server , migrates , shuts it down and then runs your alter queries against the database?

well, I have an existing database, so I want to include the tables generated for Prefect to be isolated in its own schema

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.

ah ok, too bad, I guess I have to get another DB for prefect then