Lists active pseudonymisation rules.
SHOW PSEUDONYMISATION RULES [ON|FOR <table>]## Overview SHOW PSEUDONYMISATION RULES returns a tabular result set describing all active pseudonymisation rules. Each row represents one rule and includes the target table, column pattern, pattern type, transform type, linkability scope, priority, and enabled status. This command is the primary tool for auditing which columns are currently protected and how transforms are configured. The result set is useful for verifying that newly created rules are active, confirming that dropped rules have been removed, and performing periodic compliance audits. The command accepts both the FOR and ON keywords for table filtering. ## Behavior - The executor first attempts to retrieve rules from the catalog via the CatalogRouter. If the catalog returns an empty result or is unavailable, the executor falls back to the session-scoped in-memory rule store. This ensures visibility into rules regardless of deployment context. - The result set schema contains seven columns: table_name (Utf8), column_pattern (Utf8), pattern_type (Utf8), transform_type (Utf8), scope (Utf8), priority (Int32), and enabled (Boolean). - When the table_name parameter is provided, only rules matching that table (case-insensitive) are returned. Without a filter, all rules across all tables are included. - If no pseudonymisation rules exist (either globally or for the specified table), the command returns a text message stating that no rules were found rather than an empty result batch. - Rules are returned in their stored order. Use the priority column to understand evaluation precedence when multiple rules could match the same column. ## Compatibility SHOW PSEUDONYMISATION RULES supports data governance workflows by providing a single view of all active protection policies. The output can be used to verify compliance with GDPR, HIPAA, and other data protection frameworks that require documentation of pseudonymisation measures.
| Name | Type | Description |
|---|---|---|
table_name | Specify a fully qualified table name in zone.schema.table format to filter results to a single table. When omitted, return all pseudonymisation rules across all tables in the catalog. |
SHOW PSEUDONYMISATION RULES;SHOW PSEUDONYMISATION RULES ON medical.patients;SHOW PSEUDONYMISATION RULES FOR finance.transactions;SHOW PSEUDONYMISATION RULES FOR insurance.claims;SHOW PSEUDONYMISATION RULES;SHOW PSEUDONYMISATION RULES FOR clinical.trial_participants;