catalyst-cooperative / pudl-usage-metrics

A dagster ETL for collecting and cleaning PUDL usage metrics.
MIT License
1 stars 0 forks source link

Set up database migrations #34

Open bendnorman opened 2 years ago

bendnorman commented 2 years ago

Currently, to make changes to data that already exists in the database you need to clobber the whole table. This is not ideal because the dashboard might experience downtime.

Instead, we should use a database migration tool like [alembic](https://alembic.sqlalchemy.org/en/latest/) so we can apply changes to the database without having to clobber data.

Resources