Skip to content

Privacera Plugin in Trino Open Source

This section covers how you can use Privacera Manager to generate the setup script and Trino custom configuration for SSL to install Privacera Plugin in an open-source Trino environment.

Privacera Trino supports Trino Open Source with the following catalogs.

  • Hive
  • PostgreSQL DB
  • Redshift

Prerequisites

Ensure the following prerequisites are met:

  • A working Trino environment
  • Privacera services must be up and running.

Configuration

  1. SSH to the instance as USER

  2. Run the following commands.

    cd ~/privacera/privacera-manager
    cp config/sample-vars/vars.trino.opensource.yml config/custom-vars/
    vi config/custom-vars/vars.trino.opensource.yml
    
  3. Edit the following properties. For property details and description, click here.

    TRINO_STANDALONE_ENABLE: "true"
    TRINO_USER_HOME: "<PLEASE_CHANGE>"
    TRINO_INSTALL_DIR_NAME: "<PLEASE_CHANGE>"
    
  4. Run the following commands.

    cd ~/privacera/privacera-manager
    ./privacera-manager.sh update
    

    After the update is complete, the setup script (privacera_trino_setup.sh) and Trino custom configurations (privacera_trino_plugin_conf.zip) for SSL will be generated at the path, cd ~/privacera/privacera-manager/output/trino-standalone.

  5. In your Trino environment, do the following:

    1. Copy privacera_trino_setup.sh and privacera_trino_plugin_conf.zip. Both the files should be placed under the same folder.
    2. Add permissions to execute the script.

      chmod +x privacera_trino_setup.sh
      
    3. Run the script to install the Privacera plugin in your Trino environment.

      ./privacera_trino_setup.sh
      

Note

To learn more about Trino, see Trino User Guide.

Migrating from PrestoSQL to Trino

To migrate your existing policies from PrestoSQL to Trino, refer to the link Migrating Steps.