We have an interesting setup right now where we provide a couple reports to each of our customers(Our customers are businesses and we have more than 30 of them, continually growing). I've been trying to find the most efficient way to do so while at the same time prevent them from ever having access to the data from other businesses.
As I understand it, I setup a new Row Level Security role for every business that we send reports to. Does anybody have any other pointers? The number of businesses we work with is constantly growing, so each time we add some I'll have to download the dataset, create a new role, re-upload then add them to the role.
In summary, my challenges are .. protecting the data while using only one dataset and sharing reports from that dataset with 20+ different external groups.
Everything I've learned has pretty much come from the community so I figured I'd ask y'all.