Skip to main content

Privacera Platform

Table of Contents

Setup Varada connector in Trino with Privacera Plugin

:
Installation

  1. Create EC2 instance. See Varada requirements documentation to learn more.

  2. SSH into EC2 instance and switch to root user.

    sudo su - root

  3. Install Java 11.

       sudo amazon-linux-extras install java-openjdk11

  4. Install trino-server.

    cd /opt   

mkdir -p /opt/trino   
mkdir -p /opt/trino/data   

cd /opt/trino/   

wget https://repo1.maven.org/maven2/io/trino/trino-server/370/trino-server-370.tar.gz   
tar -xzf trino-server-370.tar.gz   
ln -s trino-server-370  trino-server   

wget https://repo1.maven.org/maven2/io/trino/trino-cli/370/trino-cli-370-executable.jar   
chmod +x trino-cli-370-executable.jar   
ln -s trino-cli-370-executable.jar trino-cli

  5. Create the necessary configuration files in the /opt/trino/trino-server/etc directory. See the Trino documentation to learn more.

  6. Start trino-server.

     cd /opt/trino/trino-server   
./bin/launcher restart

  7. Connect trino-cli to verify trino service.

    ./trino-cli --catalog hive 
select * from customer.customer_data;

  8. Install Privacera Plugin.

Deploy Varada Connector

To learn more see: Varada Trino Connector: Community Edition Setup

  1. Download varada-trino connector, create the varada-install directory and unpack the tarball.

       mkdir /tmp/varada-install   
tar -zxf /tmp/varada-trino-connector.tar.gz -C /tmp/varada-install

  2. Then install.

    sudo python3 /tmp/varada-install/varada-connector-*-varada-con/varada/installer.py -e /tmp/varada-install/varada-connector-*-varada-con/ -o hive -c varada -w r5d.4xlarge -m s3://privacera-dev-siva -p /opt/trino/trino-server/plugin/ -d /opt/trino/trino-server/etc/ -b 8088 -u my-cluster

  3. Create workerDB directory.

    mkdir -p /var/lib/presto/varada/workerDB/

  4. Restart the trino-server.

    cd /opt/trino/trino-server   
./bin/launcher restart

  5. You can now test Privacera access control through trino-cli. To test the varada catalog you will need to add policies in privacera_trino.