Skip to content

Databricks Access Manager Policy

Create row-level and column-level filters for a Databricks data source.

  • Login to Privacera Portal.

  • On the Privacera Portal home page, expand Access Management and click the Resource Policies from the left menu.

  • On the Resource Policies page, go to privacera_hive  and click Row Level Filter tab.

  • Click Add New Policy to create row level filter for Databricks.

  • Enter the Policy Name. E.g. Sales by Country

  • Enter the Hive Database name. E.g. sales (This is a filter condition) 

  • Enter the Hive Table name. E.g. sales_data (This is a filter condition) 

  • Under Row Level Conditions:

    • Select the User.

    • Select the permission as 'Select'.

  • Click Save. The Row Level filter for Databricks is added successfully.

Column Level Access Control#

  • Login to Privacera Portal.

  • On the Privacera Portal home page, expand Access Management and click the Resource Policies from the left menu.

  • On the Resource Policies page, go to privacera_hive  and click Add New Policy to create column level filter for Databricks.

  • Create a policy for explicit permission for columns to users.

    • Enter the Policy Name.

    • Select the Database, Table, and Column where you need to apply this filter.

  • Click Save. The Column Level filter for Databricks policy is added successfully.

Check audit for the above executed command in Privacera Access Manager using the below steps:

  • On the Privacera Portal home page, expand Access Management and click the Audit from the left menu.

Last update: July 23, 2021