YouPrep data filtering with a user attribute

In this section, we'll explore the process of enhancing your data security through dynamic row-level filtering with YouPrep. By utilizing user attributes, you can efficiently filter tables and implement robust row-level security. This feature proves invaluable, especially in scenarios involving a multi-tenant data architecture where data for all users is consolidated within a single table.

It's highly recommended as an App-builder to be connected with an account that has the user attributes used that are set. This ensures a smooth and efficient configuration process. If you are not connected with a user having those user attributes, the variables won't be listed in YouPrep.

Let's delve into the steps to seamlessly achieve this dynamic row-level filtering and fortify your data management within Toucan environment:

• Add a “Filter rows” step

• Select the column to filter on, and then click on the “Variable” icon and select the user attribute (customer_id in the example below).

Note that there is also a dedicated feature called Permissions, that allows to configure Row-Level-Security on datasets.