Results not added to dedicated Postgres database for Elementary

[stalerik95]

Hi there,

I'm building a data warehouse using dbt, Dagster and Postgres, and have just found out about Elementary. Seems super cool!

In the quick start guide, it says that "we recommend creating a dedicated database, or at least a schema". For my use case, I'd very much like to have a dedicated database for Elementary. This is because I in effect run multiple parallel data warehouses, targeting different Postgres databases. However, it would be super neat to have all of the test results collected into one central location.

I've tried targeting one static database in the elementary profile, as opposed my other profile, which has a dynamic database config. However, when I run tests with this setup, the results aren't added to my elementary database. I guess this is because Postgres databases aren't connected, even though they're on the same instance.

All help is appreciated!

// Erik