Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
SVV_MASKING_POLICY
Use SVV_MASKING_POLICY to view all masking policies created on the cluster.
Only superusers and users with the sys:secadmin role can view SVV_MASKING_POLICY. Regular users will see 0 rows.
Table columns
| Column name | Data type | Description |
|---|---|---|
| policy_database | text | The name of the database in which the masking policy was created. |
| policy_name | text | The name of the masking policy. |
| input_columns | text | The attributes provided in the WITH clause of CREATE POLICY statement. |
| policy_expression | text | The masking expression used in the policy. |
| policy_modified_by | text | The name of the user who last modified the policy. |
| policy_modified_time | timestamp | The timestamp of when the policy was created or last modified. |
