Prerequisites for Databricks SQL¶
Privacera's Databricks SQL connector integrates with Databricks SQL warehouses to manage access permissions and policies. The connector requires appropriate credentials and privileges to connect to your Databricks workspace and manage SQL-based access control. This section outlines the essential prerequisites for setting up the Databricks SQL connector with Privacera.
Prerequisites¶
| Prerequisites | Detail |
|---|---|
| Databricks Workspace URL | Obtain the URL for your Databricks workspace (e.g., https://your-workspace.cloud.databricks.com). |
| Databricks Service User and Credentials | This connector requires a service user with the appropriate privileges to manage access policies. The service user must have access to SQL warehouses and the ability to manage permissions on databases and tables. |
| SQL Warehouse | A running SQL Warehouse is required for the connector to execute SQL commands and manage access permissions. |
| JDBC URL | Get the JDBC URL for the Databricks SQL warehouse. The URL format should be: jdbc:databricks://your-workspace.cloud.databricks.com:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=sql/1.0/warehouses/warehouse-id |
| Personal Access Token | Databricks personal access token with sufficient privileges. |
| Database and Table Identification | Identify the databases and tables in Databricks SQL for which you want to manage access control using Ranger policies. |
| Principal Identification | Identify the users, groups, and roles in Databricks to which access control policies will be applied using Ranger policies. |
- Prev topic: Access Management Overview
- Next topic: Setup