Does anyone know how to setup dagster to save run logs to a .duckdb file? Right now my run is not saved, because there a no

DAGSTER_HOME

var set in the

.env

file

As far as I know you can only save run logs to sqlite (default), postgres, or mysql.

Thanks @DB would you happen to have an example setup?

If you set the DAGSTER_HOME environment variable to some absolute path, dagster will create an sqlite run storage there automatically. For example (on windows), you can create some

run_dagster.bat

set DAGSTER_HOME=c:\dagster_home
call venv\scripts\activate
dagster dev -f foo.py

Postgres is a bit more involved, but it can be useful in production for performance reasons if you have many (say 100+) assets. See here for details on that.

thnaks ofr the tip @DB! 😄