This topic describes how to add a MySQL DuckDB data source to connect Quick BI to an Alibaba Cloud RDS MySQL DuckDB database. After the data source is added, you can use Quick BI to analyze and visualize data from the database.
Prerequisite
A DuckDB-based analytical instance is created. For more information, see DuckDB-based analytical instance.
Procedure
Add IP addresses to a whitelist.
Before you connect to your Alibaba Cloud RDS for MySQL with DuckDB database over a public network, add the IP addresses of Quick BI to the database whitelist. For more information, see Configure a whitelist.
Log on to the Quick BI console.
You can access the Create Data Source interface as described in Create Data Source entry point.
On the Alibaba Cloud Databases tab, select the RDS for MySQL with DuckDB data source.
In the Configure Connection dialog box, set the parameters as required.
Name
Description
Display Name
The display name of the data source in the data source list.
Enter a name that meets the requirements. Do not use special characters. The name cannot contain leading or trailing spaces.
Database Address
The public endpoint of the MySQL with DuckDB database.
If you use a VPC data source, enter the private endpoint of the database.
Log on to the RDS console. In the Basic Information section, click View Connection Details to obtain the database endpoint. For example: rm-xxxxxxxxxxxxxxxxxx.mysql.rds.aliyuncs.com.
Port
The port number of the database. The default value is 3306.
If you use a VPC data source, enter the private port of the database.
Database
The name of the database that you want to connect to.
Username and Password
The username and password for the database.
Make sure the account has the create, insert, update, and delete permissions on the tables in the database.
Database Version
Select the version of the database.
If the database type is MySQL 5.7 or earlier, select 5.7.
If the database type is MySQL 8.0, select 8.0.
VPC Data Source
If you use an Alibaba Cloud VPC network, select VPC Data Source and configure the following parameters:
Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey secret with access permissions to the target MySQL DuckDB database.
Make sure the account has the Read permission on the destination instance. If the account also has the Write permission, the system automatically adds IP addresses to the whitelist. Otherwise, you must manually add them. For more information about how to create custom policies, see Create a custom policy.
Log on to the RAM console to obtain the AccessKey ID and AccessKey secret.
Instance ID and Region: The ID and region of the MySQL with DuckDB database instance. Log on to the RDS console to obtain this information.
NoteIf you select VPC Data Source, you must enter the private endpoint and private port for the database address and port.
SSL
If the destination data source has SSL configured, select SSL to protect your data.
Initialization SQL
After you enable this option, you can configure SQL statements that are executed for initialization after a data source connection is established.
The SQL statements that are executed for initialization each time a data source connection is established can only be SET statements. Separate multiple statements with semicolons.
Enable File Upload
After you enable this option, you can upload local files to this database.
Click Test Connection to test the connectivity to the data source.
After the test is successful, click OK to add the data source.
What to do next
After you create the data source, you can create datasets and analyze data.
To add data tables from the Alibaba Cloud RDS for MySQL with DuckDB database or custom SQL statements to Quick BI, see Create a dataset.
To create charts and dashboards for data visualization and analysis, see Create a dashboard and Overview of charts.
To drill down into your data for in-depth analysis, see Step 3: Configure and display drill-down data.