Skip to content

Row-Level Data Reduction- Private Preview

3 min read · Updated 4 Nov 2026

Row-Level data reduction restricts access to data based on the characteristics of the person viewing the data.

Astrato supports.

Row-level data reduction presents each user with only the specific rows in the data he has permission to view.

Astrato data reduction can be set using these user attributes:

  • User email address

  • User membership in Astrato’s groups.

Data reduction is done on a defined set of columns in a table.

When global data reduction is enabled, all queries that reference tables related to the table with the data reduction rule will be filtered.



Data reduction is configured in the semantic layer editor.
To define a data reduction rule, follow these steps:

  • Select the target table in Map View, or in Tables & Fields, to open the table’s panel
    ​

    Table context menu in the data model with View/Edit table highlighted, above the Territory Data table.

  • Expand Pre-filter in the panel to define the data reduction rule

    Territory Data table preview with the filter icon at top right and the empty Pre-Filter Territory Data dialog open.

    ​

    • Select the email address field in the table, and define the data reduction as displayed in the image below.

    • Select Equals as the operator, and change Value to User Attribute.

    • Choose the $userEmail attribute (this is the system attribute).

    • Pre-Filter Customer Data dialog: Customer Email Equals Parameter, with $userEmail as value and parameter name user_email.

    • Select the field in the table with matching group names, and define the data reduction as displayed in the image below.

    • Select In list as the operator, and change Value to User Attribute.

    • Choose the $userGroupNames attribute (this is the system attribute).

    • Pre-Filter Territory Data dialog: Sales Country In list Parameter, with $userGroupNames as value and parameter name groups filter.

Global data reduction means that the filter defined in the table is applied whenever a field or measure from a table connected to the source table is used.

To enable global data reduction, follow these steps:

  • Check the box Apply as global data reduction

  • Optionally, check the box Strict, which appears once the first box is checked
    When Apply as global data reduction is not checked, the filter is not applied to the connected tables.

Below is an image of a filter applied as a global data reduction
​

Pre-Filter Territory Data dialog with Apply as global data reduction and Enabled both checked and highlighted.

To edit an existing data reduction rule, follow this process:

  • Open the Semantic layer editor and select the table with a shield and filter icon, in Map View or Tables & Fields

  • Find the table with a filter icon, and a shield when the rule uses a user attribute
    ​

    Data model with the Territory Data table highlighted, showing a lock icon and a filter icon in its header.

  • Expand Pre-filter in the table’s panel

  • Edit the data reduction settings and select Update.

When a global data reduction is applied, all charts that use fields from tables connected to the data reduction table will be filtered.

Let’s look at an example:
In this example, all tables are connected to the Territory Data table, where a global data reduction is active.

Data model with Sales Data linked to Customer, Geography, Product and Territory tables; Territory Data has a lock and filter icon.

Now, if we look at the list of cities from the Geography data table, it’ll display only the cities that had activity related to the filtered countries in the Territory Data table.

The same will apply to the list of products or dates.
​

​