Table level data masking issue

[Harish_Kumar_M]

Hi,

We are seeing this error and does anyone know the ways to fix it?

[RequestId=6cf95ee8-f312-47cd-846c-dcd87158c939 ErrorClass=INVALID_PARAMETER_VALUE.ROW_COLUMN_ACCESS_POLICIES_NOT_SUPPORTED_ON_ASSIGNED_CLUSTERS] Query on table with row filter or column mask not supported on assigned clusters.

[pradeep_singh]

Check the DBR version of the cluster / compute you are using to query this table . 
Similar issue from recent past - https://kb.databricks.com/unity-catalog/analysisexception-error-when-trying-to-execute-sparkcatalogt...

[iyashk-DB]

Hi @Harish_Kumar_M , 

The error message you are encountering occurs when you try to query any table with Column masking/row filtering enabled in a single-user compute environment with DBR 15.3 or below. Currently, there is limited support for querying tables via single-user compute. You will be able to do only the following commands as follows:

• DBR 15.4–16.2: Read‑only (SELECT). DML writes aren’t supported.

• DBR 16.3+: MERGE and append writes are supported; others (e.g., simple INSERT/OVERWRITE) are not. If you’re overwriting, switch to MERGE/append or use Shared/Serverless.

Ref Doc - https://docs.databricks.com/aws/en/compute/single-user-fgac#limitations

If you want a quick fix, run the commands on Shared access mode compute (standard cluster) or a SQL Warehouse (Pro/Serverless) instead of an assigned/single‑user cluster. These environments support FGAC operations without the assigned‑cluster limitations.