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

SSH to the instance as USER

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

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>"

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.
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.