Presto data sources are available only in Quick BI Professional and Quick BI Advanced.
Prerequisites
-
Ensure network connectivity:
-
If you connect Quick BI to your Presto database over the internet, add the IP addresses of Quick BI to the database allowlist. For more information, see Add a security group rule.
-
To connect to your Presto database over an internal network, use one of the following methods:
-
If your Presto database is on an Alibaba Cloud ECS instance, connect to it through an Alibaba Cloud VPC.
-
Alternatively, connect through an SSH tunnel by using a bastion host.
-
-
-
You have created a Presto database.
-
You have the username and password for the Presto database.
Limitations
Quick BI supports PrestoDB 0.219 or later and Trino 354 or later.
Procedure
-
Log on to the Quick BI console.
-
Add a data source as instructed in the following steps.
-
Navigate to the data source creation page. For more information, see Create a data source.
-
Select Presto.
-
-
In the Configure Connection dialog box, set the following parameters.
Parameter
Description
Connection Mode
Select Standard Mode or Cluster Mode.
NoteVPC data sources and SSH tunnels are not supported in cluster mode.
Display Name
The display name for the data source. The name cannot contain special characters or leading or trailing spaces.
Database Address and Port
The endpoint (IP address or domain name) and port of the Presto database.
catalog
The Presto catalog that contains the data you want to query.
Schema
The schema to connect to.
Username and Password
The username and password for your database account.
Database Version
Two versions are currently supported: Presto and Trino.
VPCdata source
Based on your business scenario，select whether the business data source isECS VPCself-managed data source。If you selectVPCdata source，you need to configure the following parameters：
-
PurchaserAccessId：The AccessKey ID of the purchaser of this instanceAccessKey ID。
For more information, seeObtainAccessKey。
NoteMake sure that theAccessKey IDAccessKey ID has readReadpermissions。In addition，if it has writeWritepermissions，the system automatically adds the IP address to the whitelist，Otherwise, you need to manually add it。For more information, seeCreate a custom policy。
-
PurchaserAccessKey：The AccessKey secret of the purchaser of this instanceAccessKey Secret。
For more information, seeObtainAccessKey。
-
InstanceID：ECSinstanceID。Log on toECS management console，obtain the instance ID on the Instances tabID。
For more information, seeView instance information。
-
Region：ECSregion where the ECS instance is located。Log on toECS management console，obtain the region where the instance is located in the upper-left corner。
For more information, seeView instance information。
NoteVPC data sources are not supported in cluster modeVPC.。
SSL
If SSL is configured for the target data sourceSSL，, you can also select， SSL， to ensure data security。
SSH
Based on your business scenario，, choose whether the connection method of the business data source is SSH。If you selectSSH，, you need to configure the following parameters：
-
SSH Host：hostname or IPaddress。
-
SSH username：databaseSSHusername。
-
SSH password：database username password。
-
SSH port：database port。Default is22。
NoteCluster mode does not support usingSSH。
InitializationSQL
After enabled，you can configure SQLSQLstatements。
SQLSQLstatements，onlySETstatements，statements are separated by semicolons。
-
-
Click Connection Test to test the data source connectivity.
-
After a successful test, click OK to add the data source.
Next steps
After you create a data source, you can create datasets and analyze data.
-
Add data tables from a Presto database or custom SQL to Quick BI. For more information, see Create and manage datasets.
-
Add visualizations and analyze data. For more information, see Create a new dashboard and Visualization overview.
-
Drill down and analyze your data in depth. For more information, see Step 3: Drill-down settings and display.