Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Audience: Data Users
Content Summary: This page offers a tutorial on how to query data within the Databricks SQL integration.
Prerequisites:
REVOKE
users' access to raw tables
Select SQL from the upper left menu in Databricks.
Click Create → Query.
Select the Immuta database name used when configuring the integration.
Query the Immuta-protected data, which takes the form of immuta_database.backing_database_table_name
:
Immuta Database: The Immuta database name used when configuring the integration.
Backing Database: The database that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query (you must include the database). It should look something like this:
Audience: Data Users
Prerequisites:
Query the data exactly as you would have before Immuta.
Prerequisite: Users have been granted SELECT
privileges on all or relevant Snowflake tables
Query the data exactly as you would have before Immuta.
Prerequisite: REVOKE
users' access to backing tables
Create a new worksheet.
Select the appropriate role/database/schema to query the views:
Role: any or just PUBLIC.
Warehouse: any.
Schema: The schema that houses the backing tables of your Immuta data sources.
Run the following query in the worksheet (replace IMMUTA
with the name of your database and replace TABLE.NAME
with the name of the backing Snowflake table):
Audience: Data Users
Prerequisites:
REVOKE
users' access to raw tables
Use your tool of choice to connect to Starburst (Trino).
Query the Immuta-protected data, which takes the form of immuta_catalog.backing_schema.table_name
:
Backing Schema: The schema that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query (it is recommended that you use the catalog in the query). It should look something like this:
Content Summary: This page offers a tutorial on how to query data within the .
Database: The Immuta database name used when (default is IMMUTA).
Content Summary: This page offers a tutorial on how to query data within the .
Select the Immuta catalog name used when .
Immuta Catalog: The Immuta catalog name used when .
Audience: Data Users
Content Summary: This page offers a tutorial on how to query data within the Databricks integration.
Prerequisites:
Create a new workspace.
Query the Immuta-protected data, which takes the form of database.table_name
:
Database: The database that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query, it should look something like:
Create a new workspace.
Query the Immuta-protected data, which takes the form of database.table_name
:
Database: The database that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query. It should look something like this:
Create a new workspace.
Run:
In the same workspace, but a different cell, query the Immuta-protected data, which takes the form of database.table_name
:
Database: The database that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query. It should look something like this:
Query the Immuta-protected data, which takes the form of database.table_name
:
Database: The database that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query. It should look something like this:
Audience: Data Users
Content Summary: This page offers a tutorial on how to query data within the Redshift integration.
Prerequisites:
REVOKE
users' access to raw tables
Use your tool of choice to connect to Redshift.
Select the Immuta database name used when configuring the integration.
Query the Immuta-protected data, which takes the form of immuta_database.backing_schema.table_name
:
Immuta Database: The Immuta database name used when configuring the integration.
Backing Schema: The schema that houses the backing tables of your Immuta data sources.
Table Name: The name of the table backing your Immuta data sources.
Run your query (it is recommended that you use the catalog in the query). It should look something like this:
Audience: Data Users
Content Summary: This page offers a tutorial on how to query data within the Azure Synapse Analytics integration.
Prerequisites:
REVOKE
users' access to raw tables
GRANT
users' access to the Immuta schema
From Synapse Studio click on the Data menu on the left.
Click on the Workspace tab.
Expand databases and you should see the dedicated pool you specified when configuring the integration.
Expand the dedicated pool and you should see the Immuta schema you created when configuring the integration.
Select that schema.
Select New SQL script and then Empty script.
Run your query (note that Synapse does not support LIMIT and the SQL is case sensitive). It should look something like this: