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. To see the Trino Open Source version, click here.

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.