PDP issues

In domo, I have two different datasets, we have PDP policies on both of the datasets.
I have created two views on both of the datasets and then joined the views in a new view. I have not enabled PDP on this new view neither on other views. It should inherit the pdp from base datasets, however users are still facing issue.
What should i do to make sure that the view inherits pdp policies from base datasets.
Comments
-
@MayaU_01 - I've seen this behavior before as well and I think it has to do with how views interpret PDP in scenarios where you have two datasets, views on those datasets and then combining said views into a final view.
For example, if Dataset 1 has a PDP policy restricting data by 'Department', but dataset 2 has a policy restricting the same user by 'Region', then when the views come together in your final view, it's not actually checking the final view and then applying the filter on that final data in the view.
Instead the first view is returning rows based on PDP for the department, and the second view is returning rows based on PDP by region before the join happens to bring them together in the final view. The result of that can be a join that now has missing data and can result in weird results, no rows being returned etc.
Best practice is to make sure the PDP policies are the same across both base datasets if you are going to use views on top of views, or use a magic ETL to bring the views together and then apply PDP on that output dataset.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 824 Beast Mode
- Visualize
- 2.6K Charting
- 88 App Studio
- 46 Variables
- Automate
- 195 Apps
- 486 APIs & Domo Developer
- 93 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive