• alembic migrations are supposed to be static, and best practises say you should include the schema in the migrations itself. but off course that's not feasible here as the schema should be configurable
• i don't think the schema support can be db-independent since not all dbs even support schemas
so i really wonder if its worth to continue the route i took
03/24/2022, 4:15 PM
So, our alembic migrations aren’t really db-agnostic. We have different alembic paths across our dbs, in part because we diverged early on and never reconciled the alembic hashes across mysql/postgres/sqlite.
I think you’re on the right path… we could alter all of our postgres-alembic scripts to take an optional schema argument into its ops.
04/26/2022, 3:55 PM
in the end, we went for a much simpler solution, might be interesting for others too: in postgres you can create a specific user with a default schema. and other than i was expecting, when you do that, then dagster nicely creates all its stuff in that schema.