Skip to content

Dremio User Guide

Run Queries

Select Data in Table

Note

Privacera Plugin with Dremio supports access control only for SELECT queries on tables.

Privacera Plugin uses the privacera_dremio repository for access control.

  1. Run the following command:

    select * from test_catalog.test_db.test_table
    

    In Privacera Portal, when you check Access Manager > Audits, access will be denied.

  2. In Privacera Portal, create an access policy in Access Management > Resource Policies > privacera_dremio for the table and grant the Select permission as shown in the image.

  3. Run the query again. Now, you will see access is granted.