Upon further reading would it make sense to wrap SQLAlchemy

Question

Upon further reading would it make sense to wrap SQLAlchemy model classes with an IOManager class

sandy · Answer

If your ops assets are producing objects that you want to be serialized to postgres and then deserialized from postgres for downstream ops then an IO manager would be a good choice

Jo Piker · Answer

Would IO Managers still make sense if I wish to store the final results of my ops in a postgres db as opposed to say snowflake

Jo Piker · Answer

Trying to configure SQLAlchemy with an IOManager to write directly to postgres for final results Currently pickling and writing to S3 for intermediary steps

sandy · Answer

yeah from Dagster s perspective there s no difference between snowflake and postgres

sandy · Answer

you can use different IO managers at different points in your job for different assets some can go to S3 and others can go to postgres