Self-hosted Trino / Presto cluster

Configuring a Trino / Presto connection to a self-hosted cluster

1. (Optional) Make sure the network traffic from the Mitzu service (IP: 99.81.21.134) is whitelisted in your firewall config and Mitzu can access to your Trino / Presto cluster.

2. Create a principal in your Trino / Presto's authentication provider (eg. LDAP, Kerberos, etc...)

3. Add the rule below to your System Access Control file to grant read-only access to certain catalogs. Update the <user name> to the newly created user's name which will be used in Mitzu. The <data catalog> should be the name of the catalog you would like to share with Mitzu. You can share multiple catalogs by listing them all, delimited by a | character (eg. (catalog_1|catalog_2|catalog_)

   {
     "catalogs": [
        ...
        {
          "user": "<user name>",
          "catalog": "<data catalog>",
          "allow": "read-only"
        }
        ...
     ]
   }

4. Add the connection information to Mitzu at the 3rd step in the new Workspace creation or in the Manage workspace / Connection tab. Using URL Query Params you can add additional parameters to the connection. Each parameter should be in a separate row in the <parameter_name>=<parameter_value> format.

   
5. Add tables from Trino / Presto. Follow here.