Databricks SQL

Audience: Data Users

Content Summary: This page offers a tutorial on how to query data within the Databricks SQL integration.

Prerequisites:

• Databricks SQL integration configured with Immuta

• Databricks SQL tables registered as Immuta data sources

• REVOKE users' access to raw tables

Query Data

1. Select SQL from the upper left menu in Databricks.

2. Click Create → Query.

3. Select the Immuta database name used when configuring the integration.

4. Query the Immuta-protected data, which takes the form of immuta_database.backing_database_table_name:

   1. Immuta Database: The Immuta database name used when configuring the integration.

   2. Backing Database: The database that houses the backing tables of your Immuta data sources.

   3. Table Name: The name of the table backing your Immuta data sources.

5. Run your query (you must include the database). It should look something like this:

   select * from immuta_database.backing_database_table_name limit 100