Hello ! I'm not sure if my question make sense, bu...
# community-supporta
Adrien Besnard
06/20/2024, 11:25 AMHello ! I'm not sure if my question make sense, but I think I need some advice 🙂 Is it possible to merge the results of tests from multiple DBT projects into a single dashboard ? ⬇️
Adrien Besnard
06/20/2024, 11:26 AMI have a huge DBT projects which is actually splitted into multiple smaller DBT projects and instead of doing something like https://mycorp.internal/project_1/dashboard.html, https://mycorp.internal/project_2/dashboard.html
Adrien Besnard
06/20/2024, 11:26 AMHaving a single dashboard that merge everything
a
Alex L
06/20/2024, 12:04 PM@Adrien Besnard what about that setup isn’t working now?
Alex L
06/20/2024, 12:05 PMAre they actual different dbt projects with their own dbt_project.yml or is it 1 project broken up via model selectors
a
Adrien Besnard
06/20/2024, 12:09 PMIt's different dbt_projects with different dbt_projects.yml
a
Alex L
06/20/2024, 12:11 PM🤔 have you tried creating a facade schema that mimics the elementary schema, but each relation is actually a view unioning your sub-project’s elementary schema?
a
Adrien Besnard
06/20/2024, 12:12 PMYou're right, it can work: It'll require some code generation at some point but I think that's doable that way
a
Alex L
06/20/2024, 12:17 PMI’m fairly sure there isn’t a built in way- my experience with the edr code is that it’s fairly straightforward though, so forking the cli generate-report would be my 2nd try if ☝️didn’t work like i wanted
a
Adrien Besnard
06/20/2024, 12:18 PMI'll try when I'll be faced to that: I was asking now because I know that at some point I'll be up to that point.
Adrien Besnard
06/20/2024, 12:18 PMI'll update that Slack thread to tell you how it goes
Adrien Besnard
06/20/2024, 12:18 PMThanks!
👍 1
29 Views