Skip to content

Enable Secure View

Trust3 AI supports Secure View for the Dremio connector. This feature enables you to create views on top of existing tables while enforcing row-level security (RLS) and column-level masking policies.

For more information, refer to the About Secure Views section.

Configuration

  1. SSH to the instance where Privacera Manager is installed.

  2. Run the following command to open the .yml file to be edited.

    If you have multiple connectors, then replace instance1 with the appropriate connector instance name.

    Bash
    vi ~/privacera/privacera-manager/config/custom-vars/connectors/dremio/instance1/vars.connector.dremio.yml
    
  3. To enable secure view update the following properties to true:

    YAML
    1
    2
    3
    4
    CONNECTOR_DREMIO_ENABLE_VIEW_BASED_MASKING: "true"
    CONNECTOR_DREMIO_ENABLE_VIEW_BASED_ROW_FILTER: "true"
    CONNECTOR_DREMIO_SECURE_VIEW_CREATE_FOR_ALL: "true"
    CONNECTOR_DREMIO_ENABLE_DATA_ADMIN: "true"
    

  4. Ensure the following native options are disabled:

    YAML
    CONNECTOR_DREMIO_ENABLE_ROW_FILTER: "false"
    CONNECTOR_DREMIO_ENABLE_MASKING: "false"
    

  5. Configure native column-level access control:

    YAML
    CONNECTOR_DREMIO_COLUMN_ACCESS_CONTROL_TYPE: "view"
    

  6. Set default masked values:

    YAML
    1
    2
    3
    CONNECTOR_DREMIO_MASKED_NUMBER_VALUE: "<MASKED_NUMBER_VALUE>"
    CONNECTOR_DREMIO_MASKED_TEXT_VALUE: "<MASKED_TEXT_VALUE>"
    CONNECTOR_DREMIO_MASKED_DOUBLE_VALUE: "<MASKED_DOUBLE_VALUE>"
    

  7. Set view naming conventions (optional):

    YAML
    1
    2
    3
     CONNECTOR_DREMIO_SECURE_SPACE_PREFIX: ""
     CONNECTOR_DREMIO_SECURE_SPACE_POSTFIX: ""
     CONNECTOR_DREMIO_SECURE_SPACE_REMOVE_SUFFIX_LIST: ""
    

  8. Once the properties are configured, run the following commands to update your Privacera Manager platform instance:

    Step 1 - Setup which generates the helm charts. This step usually takes few minutes.

    Bash
    cd ~/privacera/privacera-manager
    ./privacera-manager.sh setup
    
    Step 2 - Apply the Privacera Manager helm charts.
    Bash
    cd ~/privacera/privacera-manager
    ./pm_with_helm.sh upgrade
    
    Step 3 - (Optional) Post-installation step which generates Plugin tar ball, updates Route 53 DNS and so on. This step is not required if you are updating only connector properties.

    Bash
    cd ~/privacera/privacera-manager
    ./privacera-manager.sh post-install