Accessing Data

Once data is registered through the Teradata connection, you will access your data through your Teradata client as you normally would. If you are subscribed to the data source, Immuta grants you access to the data in Teradata.

When you submit a query, the Teradata client submits the SQL query to the Teradata server, which then processes the query and determines what data your role is allowed to see. Then, the Teradata server queries the database and returns the query results to the Teradata client, which then returns policy-enforced data to you.

The diagram below illustrates how Immuta, the Teradata server, and Teradata client interact to access data.

Querying data

Because subscription policies are managed through roles, you must be acting under the role Immuta creates for you to get access to your subscribed data sources.

When querying data in Teradata, use SET ROLE ALL, which allows you to use the privileges from all roles that have been granted to your user, including the immuta_<username> role and your current active primary role.

While data policies do replace original views with Immuta-managed view, the new view will be in the same database as the original view with the same name. So there is no impact to the way you must query an Immuta vs non-Immuta managed view.