Hello Everyone Is it possible to store elementary data in a different database(different host) than main warehouse database? As I see I can run

dbt -s elementary  --target=other_host

and it works - it loads data from dbt artifacts to postgres db Also when I run it again it appends data which is great So in theory instead of configuring elementary in dbt yml file(because then elementary uses main project profile) I could run this command after each dbt build/run/test Will I loose some benefits in that way ? Thank you

Hey @Wojciech, dbt always run with access to a single warehouse, it's not intended for cross warehouses pipelines by itself. Artifacts appear in your different host since our package takes them from dbt graph, which is a local state of dbt and dbt neither relays on the warehouse nor need access to the actual data. But things like tests,

dbt run

results, cannot be saved on a different db.