Steps to reproduce this error:
Step 1: I have a Big query which has couple of columns & "email" column is clustered.
Step 2: I have also applied Policy tagging (dynamic data masking) on this clustered column.
Step 3: Post applying I am unable to query this entire table & it throws an error
Sample screenshots below:
"email" column is clustered:
From the error "Data masking cannot be applied" data masking is applied on each column using the policy tags mentioned & now it is not possible on clustered columns.
I need to apply dynamic data masking feature in Big query for a clustered column. I can find this as a limitation in Google docs here but, what is the reason behind it?