Databricks Access Pattern
Audience: Data Owners and Data Users
Content Summary: This page provides an overview of the Databricks access pattern.
Installation Details: If you are using the Immuta free trial, please configure Databricks using the Databricks quickstart button in the left sidebar of your Immuta instance:
Otherwise, see the Databricks Installation Guide.
The Immuta Databricks integration allows you to protect access to tables and manage row-, column-, and cell-level controls without enabling table ACLs or credential passthrough. Like other integrations, policies are applied to the plan that Spark builds for a user's query and enforced live on-cluster.
Using Immuta with Databricks
Usernames in Immuta must match usernames in Databricks. It is best practice is to use the same identity manager for Immuta that you use for Databricks (Immuta supports all common identity manager protocols); however, for free trial users, it’s easiest to just ensure usernames match between systems.
You should use a Databricks administrator account to register tables with Immuta using the UI or API; however, you should not test Immuta policies using a Databricks administrator account, as they are able to bypass controls. See the “Testing the Integration” section below for more details.
Ideally, you should register entire databases and run schema monitoring jobs through the python script provided during data source registration.
Testing the Integration
Test the integration on an Immuta-enabled cluster with a user that is not a Databricks administrator. To illustrate table access and policy controls, we will use two example accounts: Bob (test account) and Emily (administrator account).
The administrator, Emily, can control who has access to specific tables in Databricks. The analyst, Bob, will only see
immuta database with no tables in it until he has gained access to tables through Immuta
Subscription Policies Emily sets or by being
manually added to the data source
Therefore, if Emily registers a database called
fruit with tables
apple, once Bob has
subscribed to those tables through Immuta, he will see the
fruit database and its tables and be able to query them.
Note: If Bob tries to query those tables before being subscribed, he will be blocked.
All tables registered in Immuta will also appear in the
immuta database, allowing for a single database for all
tables, so in our example Bob would see
fruit.apple, and in the
he would see
Immuta will also contain tables that are not in Databricks; if Emily had Athena tables registered with
Immuta, they would show in the
immuta database and would be queryable through Databricks. (Immuta automatically
Fine-grained Access Control
Once Bob is subscribed to the
fruit database tables, Emily can apply fine-grained access controls,
such as restricting rows or masking columns with advanced anonymization techniques, to manage what Bob can see in each
table. More details on Data Policies can be found here.
All access controls must go through SQL.
df = spark.sql("select * from fruit.kiwi")
import org.apache.spark.sql.SparkSession val spark = SparkSession .builder() .appName("Spark SQL basic example") .config("spark.some.config.option", "some-value") .getOrCreate() val sqlDF = spark.sql("SELECT * FROM fruit.kiwi")
%sql select * from fruit.kiwi
library(SparkR) df <- SparkR::sql("SELECT * from fruit.kiwi")
Note: With R, you must load the SparkR library in a cell before accessing the data.