User-level visibility controls for metric categories in metrics catalog

[jesshitchcock]

Currently, Lightdash allows managing access to specific metrics, dimensions, rows, and explores using user attributes. However, there is no way to limit visibility of entire metric categories in the metrics catalog based on user or group.

Feature details:

• Allow admins to specify which users or groups can see specific metric categories in the metrics catalog.
• This should work for projects connected directly to dbt Cloud (i.e., without requiring lightdash.config.yml).
• Ideally, this would extend to other content types, such as explores, to allow more granular permission sets.

Why it's needed:

• Some organizations want to restrict access to certain categories of metrics for specific users or teams.
• More granular permission sets would allow for better data governance and user experience.

Related docs: User attributes documentation

Suggested implementation:

• Add a way to define visibility rules for metric categories at the user or group level, possibly via the UI or user attributes.
• Ensure compatibility with dbt Cloud-connected projects.

Acceptance criteria:

• Admins can restrict metric category visibility by user or group.
• Users only see metric categories they have access to in the metrics catalog.
• Works for dbt Cloud-connected projects.

[linear[bot]]

PROD-1163

[lightdash-bot]

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C08K4R814RJ/p1765273878564689?thread_ts=1765273878.564689&cid=C08K4R814RJ

[lightdash-bot]

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C08K4R814RJ/p1765273878564689?thread_ts=1765273878.564689&cid=C08K4R814RJ