Data Security at the level of columns or rows or Data masking

BS_THE_ANALYST
Databricks Partner

‎08-16-2025 03:38 PM

Hi everyone, 

I'm currently going through the Data Analyst learning path. I've just learned about Dynamic Views and I wanted to share the article on them: https://docs.databricks.com/aws/en/views/dynamic#before-you-begin 

There are some limitations on using them:

  • A SQL warehouse.
  • Compute with standard access mode (formerly shared access mode).
  • Compute with dedicated access mode (formerly single user access mode) on Databricks Runtime 15.4 LTS or above.

But if that's not a problem, then they're awesome! 

The example provided in the docs:

BS_THE_ANALYST_0-1755383776603.png

It's just awesome to see how simple it is. Just leveraging a CASE statement and group memberships. And you can use the same technique for Rows/Columns/Masking.

I'm curious to see if anyone has used them and has feedback on what they're like in production!

All the best,
BS