Hello everyone … I have a question about Elementary with PostgreSQL as metadata Db … my models target DB is SQL Server, but I need to use elementary in PostgreSQL, as elementary doesn’t support SQL Server as metadata db … do I need to do some specific config to get work ? because now, when I run my models, in elementary macros, it invokes sql server to create tables and fail …

Hi @Fulvio Mascara, Unfortunately this isn't possible 🥹 Elementary is a package in your dbt project and runs as a part of it, so it cannot have a different target

hi @Ella Katz … so if my target db for models is sqlserver, I can’t have elementary in postgresql, even if I configure with different profiles, that’s it ?

The setup of running Elementary with a different target than dbt isn't an option, however there is an ongoing effort of contributors to add support for Elementary on sqlserver! You can see it here: https://github.com/elementary-data/elementary/issues/353

Thank you @Ella Katz … I gonna check it out …