You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Jul 10, 2024. It is now read-only.
When a column has masking policies configured and the column is called inside a function. The output of the function is not returning masked data.
For example, let's say if a column abc from table default_table has HASH_MASK policy configured for a user XYZ. Below are a couple of queries where the user might get actual abc value instead of masked value.
select substr(abc, 0, 100000000000) from default_table
select concat(abc, '-', 'dummy') from default_table
When a column has masking policies configured and the column is called inside a function. The output of the function is not returning masked data.
For example, let's say if a column
abcfrom tabledefault_tablehasHASH_MASKpolicy configured for a userXYZ. Below are a couple of queries where the user might get actualabcvalue instead of masked value.