Quick BI:Add a Presto Data Source

Procedure

1. Log on to the or the international Quick BI console.

2. Follow the steps in the figure below to add a data source.

   1. Navigate to the data source creation page via the data source creation entry.

   2. Select Presto as the data source type.

      

3. In the Configure Connection dialog box, fill in the required fields.

   Name	Description
   Connection mode	Supports selecting NAT mode or Cluster mode. Note VPC data sources and SSH are not supported in cluster mode.
   Display Name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address	The address where the Presto database is deployed, including the IP address or domain name.
   Port	When the connection mode is NAT mode, you need to enter the port number of the database. Default value: 3306.
   Catalog	The data source that you use Presto to query.
   Schema	The schema of the database that you want to access.
   Username and Password	The username and password that are used to access the database.
   Database version	Currently supports PrestoDB and Trino versions.
   VPC Data Source	Based on your business scenario, specify whether the business data source is a user-created ECS VPC data source. If you select VPC Data Source, you need to configure the following parameters: Purchaser Accessid: The AccessKey ID of the purchaser of this instance. For more information, see obtain an AccessKey. Note Ensure that the AccessKey ID has Read permission on the destination instance. If it has Write permission, the system automatically adds the whitelist. Otherwise, you need to add it manually. For more information, see create a custom policy. Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance. For more information, see obtain an AccessKey. Instance ID: The ECS instance ID. Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see view instance information. Area: The area where the ECS instance is located. Log on to the ECS console and obtain the area in the upper-left corner. For more information, see view instance information. Note VPC data sources are not supported in cluster mode.
   SSL	If the destination data source is configured with SSL, you can also select the SSL security protocol to protect data security when connecting to the destination database.
   SSH	Based on your business scenario, specify whether the connection method of the business data source is SSH. If you select SSH, you need to configure the following parameters: SSH Host: The hostname or IP address. SSH Username: The SSH username of the database. SSH Password: The username password of the database. SSH Port: The port of the database. Default value: 22. Note SSH is not supported in cluster mode.
   Initialization SQL	You can select this option to set initialization SQL. The SQL statement that is executed after each data source connection is initialized. Only SET statements are allowed, and statements are separated by periods.

4. Click Connection Test to verify the data source connectivity.

   

5. Once the test is successful, click OK to finalize the data source addition.