Trino
Connection Type | ODBC (64-bit) |
Driver Details | You can download the driver from Alteryx download page. |
Type of Support | Read and Write (Materialized tables only) |
Validated On | Client Version: Simba Trino 2.2.1.1002 |
Authentication method | No authentication Username / password |
Alteryx Tools Used to Connect
Standard Workflow Processing
Input Data Tool
Output Data Tool
Configure a Connection Using a DSN and DCM
Drag an Input Data tool or Output Data tool onto the Designer canvas.
Select the Use Data Connection Manager (DCM) check box.
In the Data Connections window, go to Data Sources and select Trino ODBC. If Alteryx can't detect an ODBC driver, a pop-up indicates that you need to install a driver.
Select +New to add a new data source in the Connection Manager window.
The dropdown pre-selects Trino ODBC by default.
Enter a descriptive Data Source Name for the new data source, for example, "Trino Server DSN".
Select the ODBC DSN field to see a list of available DSNs and select a DSN to use for the data source.
Select Save.
To link a credential, select + Connect Credential.
Select an Authentication Method from the dropdown.
Select Username and Password to authenticate with a username and password.
From the Credential dropdown, select an existing Credential or select Create New Credential to enter a new username and password.
Give the new credential a Credential Name.
If applicable, select a Vault.
Enter the username and password.
To use Kerberos authentication, select No Credentials. For this option, you have to configure your ODBC DSN for Kerberos authentication.
Use Test Connection to make sure it has been configured correctly.
Select Create and Link to link the new Credential to the Data Source.
Configure a DSN-less Connection Using DCM
Drag an Input Data tool or Output Data tool onto the Designer canvas.
Select the Use Data Connection Manager (DCM) check box.
In the Data Connections window, go to Data Sources and select Trino Quick Connect.
Select +New to add a new data source in the Connection Manager window opens. If Alteryx can't detect an ODBC driver, a pop up prompts you to install a driver.
The dropdown pre-selects Trino ODBC DSN-less.
Enter the information for the connection:
Enter a descriptive Data Source Name for the connection, for example, "Trino DSN-less".
Enter the Host name.
Select the Driver field to change the driver selection.
Enter the Database name.
Enter port number.
Select Save to save the new data source.
To link a credential, select + Connect Credential.
Select an Authentication Method from the dropdown.
Select Username and Password to authenticate with a username and password.
From the Credential dropdown, select an existing Credential or select Create New Credential to enter a new username and password.
Give the new credential a Credential Name.
If applicable, select a Vault.
Enter the username and password.
Use Test Connection to make sure it has been configured correctly.
Select Create and Link to link the new Credential to the Data Source.
Select Connect to use the Data Source and Credential in an Input Data our Output Data tool.