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:
- Copy privacera_trino_setup.sh and privacera_trino_plugin_conf.zip. Both the files should be placed under the same folder.
-
Add permissions to execute the script.
chmod +x privacera_trino_setup.sh
-
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.