Check for row level security and column masking

[eballinger]

Hi All,

We have sensitive tables and have applied row level security and column masking. I would like to build into our job a check to make sure these tables still have the row filters and column masks applied. This would help ensure these security filters are not accidently removed from the tables and that goes unnoticed.

Is there anyway to query this info in Python or SQL? 

Thanks

[Alberto_Umana · Accepted solution]

Hi @eballinger.

Have you tried using DESCRIBE TABLE EXTENDED on the table, that will give you details about filters applied to a table.