Skip to content

You are viewing documentation for Immuta version 2024.1.

For the latest version, view our documentation for Immuta SaaS or the latest self-hosted version.

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:

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
    

Databricks SQL Query