Guidelines for bootstrapping a database resource

[davidonlaptop]

What's the issue or suggestion?

Say you're managing postgres or ElasticSearch as dagster resources, and create all the tables as assets, is there recommendations on how to manage initializations instructions such as schema creation, user/role creations, etc. ?

Typically with rdbms you typically would do that as a database migration, but since mostly everything is created in dagster I thought there might be a best practice on where to do those operations?

Additional information

No response

Message from the maintainers

Impacted by this issue? Give it a 👍! We factor engagement into prioritization.

[davidonlaptop]

So far I have been using duckdb_init() and elasticsearch_init() assets, as dependencies.

This approach works, but just thought that resource initialization might be an interesting use case for the dagster community.