Data security for semantic models

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Security settings allow you to limit access to data by the criteria you specify, such as region or by department (group). Configure data security at the row or column level or both for saved semantic models. You can specify security access for individual users or groups. Right-click an existing rule to modify or delete it. Data security rules can be exported along with the data. Use And or Or to create complex rule conditions. Each rule can have a separate column and row-level security.

Important

Kyvos now supports Column Level Security defined in Big Query. When creating a Semantic Model with Big Query as the data source, any column level security applied in Big Query will be reflected in Kyvos when accessing data from the Semantic Model.
- The email ID of the user on Kyvos should be the same as the email ID in Google Cloud.
- The user should have Fine Grained Reader access for accessing secured columns in Kyvos and BigQuery. Without these permissions on the underlying columns, you will not be able to read the data from secured columns.
You can now create condition data security rules at the row level using both "And" and "Or" conditions. Previously, the 'And' condition was implemented by default. Now, you have the option to choose between 'OR' and 'AND' conditions.
Your organization can also configure custom row-level security (RLS) using Kyvos Manager. Then you can specify to use it from the Design tab semantic model properties page. If custom RLS is configured, you can't apply Kyvos RLS.
You MUST have sufficient security access to the data to be able to set security options.

Kyvos also allows unconditional column data masking, which is another form of security. It enables you to protect sensitive data by masking columns instead of restricting them. This feature allows for easy masking of any column data, such as SSNs, mobile numbers, credit card numbers, and email IDs, while browsing the semantic model on any BI tool.

See the section Column masking for column-level security for more details.

Setting semantic model data security

To set semantic model data security, perform the following steps.

From the Toolbox, click Semantic Models.
Click the Actions menu (...) in the work area then click Data Security.
In the Groups/ Users section, select users or groups that should have access to this semantic model.
Click to select one or more existing rules.
You can also set up rules. Click the plus sign in the Rules column to add a rule.
Click Swap to swap groups and users, and rule lists.
This option allows groups to be mapped with rules or rules to be mapped by groups.
Click Save.

Adding semantic model security rule

To add a rule, perform the following steps.

From the Toolbox, click Semantic Models.
Click the Action menu (...) in the work area, then click Data Security.
Click users or groups that this rule will apply to.
Click the plus sign in the Rules column.
Add a rule name and description.
Click Row Level or Column Level.
For Rows, choose the fields, criteria, and enter the values you want to only be accessible to the user or group.
For Columns, select a dimension, level, hierarchy, attribute, or measure.
The available choices vary depending upon the data you are using. The fields selected in this rule will not be accessible to the user or group.
Click the plus sign to add additional criteria.
Click Add.

To set up quick rules, perform the following steps.

From the Toolbox, click Semantic Models.
Select the semantic model name from the list and click the Processtab if needed.
Click the Actions menu (...) in the work area, then click Data Security.
Click users or groups to which you want to apply the rule.
Click one of the options in the Rules list:
- Allow all columns
- Allow all rows

Setting up row-level security

To set up row-level security (RLS), perform the following steps.

From the Toolbox, click Semantic Models.
Select the semantic model name from the list and click the Process tab if needed.
From Properties, scroll down to Data Security and choose one of the following as an endpoint source:
- Kyvos Internal
- CustomRLS: Displayed only if the corresponding JAR files are uploaded through Custom Data Security Configurations on the Kyvos Manager.
Select an endpoint.
Click the Define Rule and Mapping link and select Groups or Users and select the groups or users you want to use or use Search to find them.
For Rules, click Allow All Columns, Allow All Rows, or click the Plus sign next to Rules to add a custom rule.
On the Add Rule dialog, provide Rule Name and Description.
From the Row Level area, click the field link and select the field on which you want to apply the RLS.
Select the condition (And / Or) using the and link.
Click the value link, and the dialog box is displayed where you can search or select the values on which you can apply the RLS. The available choices vary depending on the data you are using.
Click Add. The RLS is applied to the selected values. you can also apply RLS on the Key value when the Hierarchy/attribute contains description (display field).
Click Row Level, and then select the click the field link, and then select the field on which you want to apply the RLS security on key field.
The RLS on Key field is applied to the values.

Setting up Column Level Security

To set up column-level security (CLS), perform the following steps.

From the Toolbox, click Semantic Models.
Select the semantic model name from the list and click the Process tab if needed.
From Properties, scroll down to Data Security and choose one of the following as an endpoint source:
- Kyvos Internal
- CustomRLS: Displayed only if the corresponding JAR files are uploaded through Custom Data Security Configurations on the Kyvos Manager.
Select an endpoint.
Click the Define Rule and Mapping link and select Groups or Users and select the groups or users you want to use or use Search to find them.
For Rules, click Allow All Columns, Allow All Rows, or click the Plus sign next to Rules to add a custom rule.
On the Add Rule dialog, provide Rule Name and Description.
From the Column Level area, select any of the following from Restrict and select the field on which you want to apply the restriction.
1. Data: Type of column level security in which only data of the column will be restricted. Any queries involving the restricted columns while browsing the semantic models are failed.
2. Data and Metadata: Type of column-level security in which both data and metadata (visibility) of the column will be restricted. If this option is selected, the restricted columns will not be visible while browsing the semantic model on any of the BI tools.