create_security_policy
Create row-level security policies in Fabric Data Warehouse by defining FILTER predicates with schema, function, and target table details.
Instructions
Create a row-level security policy.
Executes CREATE SECURITY POLICY with one or more FILTER
predicates. There is no predicate-type option (#966): Fabric Data
Warehouse supports FILTER predicates only. Each entry in predicates
must include:
fn_schema: schema of the predicate functionfn_name: name of the predicate functionfn_args: list of column names to pass to the functiontable_schema: schema of the target tabletable_name: name of the target table
Args:
workspace: Workspace name or GUID.
item: Warehouse or SQL endpoint name or GUID.
policy_name: Qualified policy name ("schema.name" or "name").
predicates: List of predicate definitions (see above).
state: Initial policy state -- True to enable, False to disable
(default: True).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| state | No | ||
| workspace | Yes | ||
| predicates | Yes | ||
| policy_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||