This article introduces how to connect to Trino to create datasets.

Before connecting to the data, contact the database administrator to collect the following information:

• The IP address and port number of the server where the database is located
• The username and password for the database

In Trino, perform the add allowlist operation, enter the "DataWind public IP for access" in the allowlist settings area, and grant this IP address permission to access the Trino service. The "DataWind public IP for access" can be viewed in Data Connections Overview.

1. Go to BytePlus, click to enter a specific project, click Data Preparation, find Data Connection in the dropdown list, and click Data Connection.

   

2. Select Trino on the page.

3. Fill in the required basic information, test the connection, and click Save after the connection is successful.
   

   • The configuration instructions for the SaaS version connection method are as follows:

     Parameters	Configuration instructions
     Data connection name	The name of the new data connection, used to distinguish connections to different databases in the system. For example, Trino_20250703144958. The name can be modified. Please enter a valid name. Only combinations of Chinese characters, English letters, numbers, and underscores are allowed, and spaces are not permitted at the beginning or end.
     Connection method	IP/Port
     Server	Trino public network address. For details, see Trino official documentation.
     Port	Trino instance port. For details, see Trino official documentation.
     Username	Username created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine.
     Password	Password created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine.
     Database	Name of the database created in Trino.
     vpcMode	Select "Yes" if the user needs to connect via the BytePlus intranet; otherwise, select "No". Select "No" here.

   • The configuration instructions for the self-hosted version connection method are as follows:

     Parameters	Configuration description
     Data connection name	Name for the new data connection, used to distinguish between different database connections in the system. For example, Trino_20250703144958. The name can be modified. Please enter a standard name. Only Chinese characters, English letters, digits, and underscores are allowed. No spaces are allowed at the beginning or end.
     Connection method	IP/Port: Suitable for general scenarios. JDBC connection string: Suitable for scenarios where users need to add connection parameters.
     Server	Trino public network address. For details, see Trino official documentation.
     Port	Trino instance port. For details, see Trino official documentation.
     JDBC connection string	JDBC connection string. For details, see Trino official documentation.
     Username	Username created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine.
     Password	Password created in the database engine. If you do not know how to obtain it, contact the operations personnel for the corresponding engine.
     Database	Name of the database created in Trino.

1. Go to BytePlus, click Data Preparation --> Dataset, and click the "New" button in the upper left corner to create a new dataset.

   

2. When selecting a data connection, click New Configuration.

   

3. The subsequent steps are the same as steps 2 and 3 in Create from data connection above. After completing the configuration, you will remain in the pop-up window to select a data connection for the dataset, and you can proceed directly to the next step to create the dataset.

1. Use the previously created data connection to create a dataset: Click Data Preparation --> Dataset, and click the "New" button in the upper left corner to create a new dataset.

   

2. Search for or select the previously created data connection from the dropdown list.

#