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:

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