Hello Akhil 🙂
Elementary is made to work over a single dbt project. However, some users in the community tried adapting it to their own needs in different approaches:
1. Merging their dbt projects into one repository (
https://discourse.getdbt.com/t/how-to-configure-your-dbt-repository-one-or-many/2121)
2. Unioning the Elementary tables created for each dbt project, and running the Elementary report over the merged tables. This should work but we have no support for it.
We’re currently tracking if any users have successfully implemented either of these approaches, and if they do, we’ll share those insights with the community.