We have a fairly complex data model, and currently no mature data layer to perform the transform step pre-metabase. This means we frequently need to effect a "transform" step in our queries in the following fashion:
Table -> Question 1 -> Question 2
Where we need no one but the data team to have access to
Question 1, and for
Question 2 to be widely sharable.
However, I can't find a way to let a user view
Question 2 without also letting them view
Question 1, which we can't allow. I can see that if I wanted I'm able to let users view
Question 1 and block
Table just fine, but that's not helpful for me here.
This feels like a really basic thing, so I'm sure I'm missing something really obvious, but I couldn't find help via search/google. Please help! Metabase isn't a usable solution currently without that ability.
N.B. In reality
Question 1 is usually built on many tables, and
Question 2 is usually formed of a mixture of tables and questions, but I don't know the complexity adds any clarity.
We're running self hosted jar, pro tier, v1.46.4.
Thank you for reading!