Data Security in BI by Antonina Stoliarova
Channel: Engineering Community
Date: 2021-06-16

We discussed general security aspects for BI Platforms and RLS (Row-Level-Security) implementation based on cumulated experience and looked into the non-trivial real business case.

In general, BI Platforms offer user-specific or group/role-specific filtering logic. But what if your case is not so straightforward and you have to consider user-specific attributes which are out of the BI Platform? How does your BI Platform deal with cached data in terms of user-specific filtering/calculations and multiple concurrent connections? What to do if your RLS logic is complex enough and kills UI performance forcing the user to wait for dashboard opening donkey's years?

The purpose of this presentation was to share challenges I had implementing RLS in different BI Platforms and ways for workarounds.