On more thing regarding dbt multiprojects: I've managed to setup smth like

elementary-umbrella

dbt project which contains only views which actually are union from source dbt-elementary projects models. Using

dbt_utils.union_relations

macro it was quite easy to do. Thanks to such approach I can now generate 1 elementary report which covers all my dbt projects on 1 web page.

We cover and support multi project in our cloud product but that's a cool initiative! 🙂

yeah. but in cloud implementation you should switch dbt project to see information. In my setup everything is on 1 page and you can just filter all you need using path, owner or tag which seems to be a bit faster.

Yeah in cloud we will be adding soon also a unified view as well

technically I have separate schema for every dbt project and +1 umbrella schema with union models