Databricks SQL Hive Service Definition

To use Databricks SQL with Privacera Hive requires Hive-specific configuration in following steps:

1. To use Databricks SQL with Privacera Hive, you need to connect Databricks application which internally creates privacera_hive. You need to connect the Databricks application, enable access, and save it.

2. Additionally, configure the following properties for Hive when you Connect Application.

   • System config: privacera-databricks_sql_analytics-hive-system-config.json

   • Add the following lines to New Properties > Custom Properties. This example uses the number 4 as the connector key.

     ranger.policysync.connector.4.ranger.service.appid=privacera_hive ranger.policysync.connector.4.ranger.service.name=privacera_hive

Note

Prior to PrivaceraCloud version 4.2, if PolicySync with the databricks_sql_analytics or hive service did not handle Ranger user/group/roles updates, add the following property where the number 4 is the connector key. This will push the new users to the Databricks workspace forcefully.

ranger.policysync.connector.4.force.update.principal=true

Hive-to-Databricks SQL Permission Mapping

Hive Permission	Databricks SQL Permission
Select	Usage, ReadMetadata, Select
Update	Usage, modify
Create in the database	Usage, Create in the database
Create on the UDF	Usage, CreateNamedFunction
Drop	No equivalent
Alter	No equivalent

---

Last update: March 4, 2022