ClickHouse breadcrumb not working past Explore -> Metrics -> Final_model

[royendo]

Describe the bug
Breadcrumbs do not work for .yaml models in a CH backed project. Therefore when pushing to main, RC doesn't seem to know which sources to refresh in which order requiring manual refreshes, also in RD its hard to know how some of these models line up.

To Reproduce
Steps to reproduce the behavior:

1. Create CH backed project,
2. Create model --> model --> model --> metrics
3. Check Breadcrumb
4. Only see Final_model -> metrics -> explore

Expected behavior
breadcrumbs should work as in Duckdb based project.

Screenshots

[begelundmuller]

@royendo Are you using {{ ref "underlying_model" }} when referencing models from other models? That is necessary for ClickHouse models (because we don't have the ability to parse ClickHouse SQL to infer what it references).

[royendo]

@begelundmuller I forgot about that! im testing it out and seeing some inconsistent behavior also, the "Referenced in this model" on the right hand panel gets cleared when using {{ ref "model }}

Dont see orb_subscription in the breadcrumb

[begelundmuller]

We identified that the frontend has some simple logic for this, it doesn't use the refs emitted by the backend. It's been fixed now.