Manage row-level access in datasets

You can manage row-level access to data on a dataset and data source levels.

Dataset level

To manage row-level access at the dataset level:

  1. Open your dataset.

  2. On the right of the field you want to manage, click Permissions.

    You'll see the Field permission settings dialog:

    permissions-dialog

  3. In the text field, specify the values to restrict access as follows:

    '[value 1]': user_email_1, user_email_2, user_email_3
    '[value 2]': user_email_2
    

    For example, to give a user with the email cto@your_company.com access to the Company-internal-ID value of the company-name field, write the following configuration:

    'Company-internal-ID': cto@your_company.com
    

    For more information, see Row-level security in Visualization.

  4. Click Save.

    Now, the Company-internal-ID value is accessible only to the cto@your_company.com account.

  5. Save the changes to your dataset.

Data source level

To manage row-level access at the data source level:

  1. Add a user id field to your data source. We'll use this field for filtering.

    You can add a new table to this field and join it using the JOIN operator.

  2. Add this field to the dataset you want to manage.

  3. Open your dataset.

  4. On the right of the field you want to manage, click Permissions.

  5. In the field permissions settings, add userid:userid and click Save.

  6. Save your dataset.