Skip to content

Databricks SQL Hive Service Definition

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

  1. In Add Databricks SQL Service Configuration, be sure to select privacera_hive as the type of service.

  2. In Add Data Source for PolicySync, configure the following additional properties:

    • 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.type=hive 
    ranger.policysync.connector.4.select.access.type.name=select
    

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: September 21, 2021