Hi Team, I would like to know if i can create elementary artifacts in a separate database, where my models/tables are not present. The reason being i want the observability tool to be in a separate system monitoring my warehouse, rather than warehouse acting as the only system.
o
Ofek Weiss
03/20/2024, 11:18 AM
Hey @Raghul s, can you provide more details? where are the models saved (db type, db name)? where do you want to save the elementary artifacts?
r
Raghul s
03/24/2024, 5:46 PM
Hi @ofek simantov I currently have my dbt models in redshift, also elementary artifacts in the same redshift database. I would like to know if can keep the elementary artifact in a seperate database like postgres?
o
Ofek Weiss
03/27/2024, 1:58 PM
That is not possible, as elementary runs as part of your dbt project, and this is not supported by dbt, you can maybe copy your elementary schema from redshift to postgres periodically