superset_rls_create
Create Row Level Security rules to automatically filter data access with custom WHERE clauses per user role and dataset.
Instructions
Create a Row Level Security rule.
RLS automatically adds a WHERE clause to queries for users with the specified roles accessing the specified datasets.
Args: name: Rule name. clause: SQL WHERE condition without the WHERE keyword. Examples: - "region = 'Moscow'" - "user_id = {{ current_user_id() }}" - "status IN ('active', 'pending')" tables: List of dataset IDs the rule applies to (from dataset_list). roles: List of role IDs the rule applies to (from role_list). filter_type: Filter type: - "Regular" (default) — additional restriction for the specified roles - "Base" — base filter applied to all users group_key: Rule grouping key (optional). description: Rule description (optional).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| roles | Yes | ||
| clause | Yes | ||
| tables | Yes | ||
| group_key | No | ||
| description | No | ||
| filter_type | No | Regular |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |