Connect Trino

1. Ensure TLS is enabled for Trino

Bigeye utilizes a username and password to connect to a Trino instance. In order for password authentication to be enabled, Trino requires that TLS be configured. The preferred method for TLS and Trino is terminating it at a load balancer. Bigeye supports connection to Trino when TLS is terminated at a load balancer. For more information, see the Trino documentation.

2. Create a read-only user for Bigeye

Enable password authentication on the Trino coordinator and create a password file with a user for Bigeye. User access can be configured at the global level, or at the level of a connector. It is up to the user on how to restrict access to Bigeye. For more information, see the Trino documentation.

3. Add Trino as a datasource in Bigeye

From the Catalog page click Add source. On the modal that appears, select Trino.

To connect a database, you will need to input the following information:

  • Alias - identifying name for this data source
  • Vendor - Trino
  • Hostname - name of the server that hosts your database
  • Port - the port of the load balancer
  • Database name - your database name
  • Username - username of the Trino read-only user you created previously
  • Password - password of the Trino read-only user you created
  • Timeout

4. Next Steps

Once you’ve added your source, Bigeye will start profiling your data to recommend autometrics. It can take up to 24 hours for this process to complete. Proceed to the Getting Started for next steps.

In addition, please consider the following:

  • Depending on your security settings, you may need to whitelist Bigeye’s static IP:
35.163.65.120
  • If you don't want all of your Trino sources to appear in Bigeye, you may have to deny access to specific connectors.