https://dagster.io/ logo
#ask-community
Title
# ask-community
r

Rene Czepluch

08/31/2023, 10:53 AM
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
d

DB

08/31/2023, 12:20 PM
As far as I know you can only save run logs to sqlite (default), postgres, or mysql.
r

Rene Czepluch

08/31/2023, 12:23 PM
Thanks @DB would you happen to have an example setup?
d

DB

08/31/2023, 12:49 PM
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
Copy code
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.
r

Rene Czepluch

08/31/2023, 1:19 PM
thnaks ofr the tip @DB! 😄