A view in Unity Catalog whose definition checks who is asking, using functions like session_user() or is_account_group_member(), and hides rows or masks columns accordingly. Give users SELECT on the view only, leaving the underlying tables ungranted.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Dynamic view in context, with comparison tables and the common traps.
Terms in this definition
- View
Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- Chat message roles
Labels on chat messages: instructions go under system, the person's input under user, the model's previous answers under assistant, and results returned by a called tool under tool (or function).
- SELECT
A DML command in SQL used to retrieve rows from one table or several.