Querying Databricks SQL Data

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