Skip to content

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