drop_column_mask
Remove a dynamic data mask from a column to expose its original values. This operation permanently removes protection and cannot be undone.
Instructions
Remove a dynamic data mask from a column.
Executes ALTER TABLE ... ALTER COLUMN ... DROP MASKED.
This is a permanently destructive operation -- the mask is removed from the
column and unmasked values become visible to all users who query the column.
Requires FABRIC_MCP_ALLOW_DESTRUCTIVE=1.
Args: workspace: Workspace name or GUID. item: Warehouse or SQL endpoint name or GUID. table_schema: Schema name of the target table. table_name: Name of the target table. column_name: Name of the column whose mask to remove.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| workspace | Yes | ||
| table_name | Yes | ||
| column_name | Yes | ||
| table_schema | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||