Just started using DBT with dagster and love it. I have a v. conventional Data Warehouse in Postgres taking in a combination of Mongo and django API data. Does anyone have any recommendations for a tool to manage the warehouse schema? I'm familiar with flyway and alembic, but haven't used either extensively.

Hey George - I'm curious what you mean by "managing" the warehouse schema. Do you mean that you want to change the set of columns in a table when the columns that you've documented in your dbt schema.yml change?

Yeah exactly, create migrations etc. Or is this not something you worry about so much in the Data Warehouse world? Think I keep getting confused with backend DB best practices.

I think it is a real issue in the data warehouse world, but I'm not aware of software that's aimed at making it easy. One of the reasons is that you don't really need it in the simplest cases: it's typical to just drop tables and recreate them every time you want to refresh them. In the more complicated cases though, Alembic could be the way to go

@sandy feel like this links in with the whole imperative vs declarative convo a bit

I think that's mostly true. An exception might be when it's too expensive to backfill an entire table, but tractable to backfill a single column