What are the known limitations of the Trino connector?
Materialized views from Trino may be displayed as tables in Atlan due to limitations at source.
How to debug test authentication and preflight check errors?
TLS/SSL required for basic authentication
TLS/SSL is required for authentication with username and password.
- Ensure that TLS/SSL is correctly configured on the Trino server. This typically involves configuring the
config.properties
file for each Trino node. Once you have updated the configuration, restart the Trino services to apply the new settings. - Ensure that the TLS/SSL certificates used by Trino are valid and unexpired.
Disabled TLS/SSL
Connection property SSLVerification requires TLS/SSL to be enabled.
- Check your connection settings to ensure that TLS/HTTPS is enabled in the crawler configuration.
Incorrect credentials
The username or the password provided to connect to the Trino account is incorrect.
- Log in to your Trino account for the specified host and verify that the username and password are correct.
- You can also create a new user, if required.
Incorrect host address
Your Trino hostname is not correct, please provide a correct hostname and retry.
The host address provided by the user is not correct, please check the host
address.
- Ensure that the hostname you have specified is correct — it should be a domain name.
Server connection failure
The host or port provided by the user is not correct, please check your host
and port.
- Ensure that the hostname you have specified is correct — it should be a domain name.
- Verify the port number.
Authentication failed: Unauthorized
Authentication failed: Unauthorized
- Verify your credentials in Trino to confirm you have the necessary permissions to connect.
SocketTimeoutException: connection timed out
Connection timed out. Please check your host and port.
- Ensure that you have specified the hostname and port number correctly in your connection settings.
- Check if you can reach the Trino server from your machine. Use
ping <host>
ortelnet <host> <port>
to test connectivity.