add_security_predicate
Adds a FILTER predicate to an existing row-level security policy. Specify workspace, warehouse, policy name, predicate function with arguments, and target table schema and name.
Instructions
Add a FILTER predicate to an existing row-level security policy.
Executes ALTER SECURITY POLICY ... ADD FILTER PREDICATE. There is
no predicate-type or operation parameter (#966): Fabric Data
Warehouse supports FILTER predicates only.
Args:
workspace: Workspace name or GUID.
item: Warehouse or SQL endpoint name or GUID.
policy_name: Qualified policy name ("schema.name" or "name").
fn_name: Name of the predicate function.
fn_args: Column names to pass to the predicate function.
table_schema: Schema name of the target table.
table_name: Name of the target table.
fn_schema: Schema name of the predicate function (optional -- omit
when the function lives in the default schema).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| fn_args | Yes | ||
| fn_name | Yes | ||
| fn_schema | No | ||
| workspace | Yes | ||
| table_name | Yes | ||
| policy_name | Yes | ||
| table_schema | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||