How do I hide details/definition for materialized views(DLT) in unity catalog
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 05:27 AM
Is there a command to hide the details of DLT/materialized views from users in UC?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2025 07:02 AM
Hi @dataminion01,
As far as I know, Unity Catalog doesn't currently provide a direct way to hide DLT or materialized view definitions. Users with SELECT access can still view the logic via the "Details" tab.
You can work around this by:
- Moving sensitive logic into User-Defined Functions (UDFs) and granting EXECUTE privileges selectively.
- Using row filters or column masks (via SQL UDFs) to dynamically protect sensitive data without exposing the full logic in view definitions.
