This topic describes how to create a Presto data source. Only Professional Edition and Premium Edition support creating Presto data sources.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to your Presto database over the public network, add Quick BI's IP addresses to your database whitelist. For more information, see Use security groups.
If you connect Quick BI to your Presto database over an internal network, use one of the following methods to ensure network connectivity between the data source and Quick BI:
If your Presto database runs on an Alibaba Cloud ECS instance, connect using Alibaba Cloud VPC.
Alternatively, set up a jump server and access the database through an SSH tunnel.
You have created a Presto database.
You have obtained the username and password for the Presto database.
Limits
PrestoDB version 0.219 and Trino version 354 or later are supported.
Procedure
Log on to the Quick BI console or the .
Add a data source as shown in the following figure.
Go to the data source creation interface from the Create data source entry.
Select the Presto data source.
In the Configure Connection dialog box, complete the following settings.
Name
Description
Connection mode
Select NAT mode or Cluster mode.
NoteVPC data sources and SSH are not supported in cluster mode.
Display name
The display name for the data source in the configuration list. Enter a valid name without special characters. Do not include leading or trailing spaces.
Database address and Port
The IP address or domain name and port of the Presto database.
Catalog
The data source used by Presto for queries.
Schema
The name of the schema to connect to.
Username and Password
The username and password for the database.
Database version
PrestoDB and Trino versions are currently supported.
VPC data source
Based on your business scenario, select whether the data source is a self-managed ECS VPC data source. If you select VPC data source, configure the following parameters:
Owner AccessKey ID: The AccessKey ID of the account that purchased the instance.
For more information, see Create an AccessKey.
NoteEnsure this AccessKey ID has read permissions on the destination instance. If it also has write permissions, the system automatically adds the IP address to the whitelist. Otherwise, you must add it manually. For more information, see Create a custom policy.
Owner AccessKey Secret: The AccessKey secret of the account that purchased the instance.
For more information, see Create an AccessKey.
Instance ID: The ECS instance ID. Log on to the ECS console and find the instance ID on the Instances tab.
For more information, see View instance information.
Region: The region where the ECS instance resides. Log on to the ECS console and check the region in the upper-left corner.
For more information, see View instance information.
NoteVPC data sources are not supported in cluster mode.
SSL
If SSL is configured for the destination data source, select SSL to secure data transmission.
SSH
Based on your business scenario, select whether to connect to the data source using SSH. If you select SSH, configure the following parameters:
SSH Host: The hostname or IP address.
SSH username: The SSH username for the database.
SSH Password: The username and password for the corresponding database.
SSH port: The port for the database. Default is 22.
NoteSSH is not supported in cluster mode.
Initialization SQL
When enabled, you can specify SQL statements to run after the data source connection is established.
Only SET statements are allowed. Separate multiple statements with semicolons.
Click Test Connection to verify connectivity.
After a successful test, click OK to complete adding the data source.
What to do next
After creating the data source, you can create datasets and analyze data.
Add tables from your Presto database or custom SQL statements to Quick BI. For more information, see Create and Manage Datasets.
Add visual charts and analyze data. For more information, see Create a Dashboard and Overview of visual charts.
Drill down for in-depth data analysis. For more information, see Step 3: Configure and display drilling.