🟦

Trino / Presto

Setup Trino / Presto Integration To Mitzu

Overview

To set up a connection with Trino / Presto, you need the following:
  • Your Trino / Presto host name
  • A user having read-only access to your data catalog
  • (Optional) Whitelisting Mitzu's IP address on your firewall

Configuring a Trino / Presto connection

If your Trino cluster is hosted by Starburst.io then follow the instructions here else follow the
  1. 1.
  2. 2.
    (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.
  3. 3.
    Create a principal in your Trino / Presto's authentication provider (eg. LDAP, Kerberos, etc...)
  4. 4.
    Add the following rule to your System Access Control file to grant read-only access to certain catalogs
{
"catalogs": [
...
{
"user": "<user name>",
"catalog": "<data catalog>",
"allow": "read-only"
}
...
]
}
Here the <user name> is the newly created user's name which will be used in Mitzu. The <data catalog> is 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_)

Add the connection information to Mitzu at the 3rd step in the new Workspace creation or in the Manage workspace / Connection tab.
Mitzu Workspace Setup
Here set a proper hostname, catalog, username and password. If you are using Starburst then you may specify your user's role as an optional Query Params like role=accountadmin
Add tables from Trino / Presto. Follow here.
Last modified 2mo ago