Add a MySQL DuckDB data source to connect Quick BI to Alibaba Cloud RDS MySQL DuckDB databases. After you successfully connect, you can analyze and visualize your data in Quick BI. This topic describes how to add an Alibaba Cloud RDS MySQL DuckDB data source.
Prerequisites
A DuckDB-based analytical instance is created. For more information, see DuckDB-based analytical instance.
Procedure
Add IP addresses to the whitelist.
Before you connect to the ApsaraDB RDS for MySQL with DuckDB database over the public network, add the IP addresses of Quick BI to the database whitelist. For instructions, see Configure a whitelist.
Log on to the Quick BI console.
Navigate to the Create Data Source interface from the entry point for creating a data source.
On the Alibaba Cloud Databases tab, select ApsaraDB RDS for MySQL with DuckDB .
In the configuration dialog box, configure the parameters.
Name
Description
Display Name
The display name for the data source in the data source list.
Enter a standard name. Do not use special characters. The name cannot contain leading or trailing spaces.
Database Address
Configure a public network address for the MySQL DuckDB database.
If you use a VPC data source, enter the private endpoint of the database.
Log on to the ApsaraDB RDS console. In the Basic Information section, click View Connection Details to obtain the database address. 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. Only MySQL 8.0 is supported. Select 8.0.
VPC Data Source
If you use an Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:
Purchaser AccessId and Purchaser AccessKey: The AccessKey ID and AccessKey secret that have permissions to access the target ApsaraDB RDS for MySQL with DuckDB database.
Make sure the account has read permissions on the target instance. If the account also has write permissions, 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 Resource Access Management (RAM) console to obtain the AccessKey ID and AccessKey secret.
Instance ID and Region: The instance ID and region of the MySQL DuckDB database. Log on to the ApsaraDB 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 parameters.
Initialize SQL
After you enable this option, you can configure SQL statements that are executed for initialization after the data source is connected.
Only SET statements are allowed. 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 verify the connection to the data source.
After a successful test, click OK to add the data source.
What to do next
After you create the data source, you can create a dataset and analyze data.
To create a dataset from data tables or custom SQL statements in your ApsaraDB RDS for MySQL with DuckDB database, see Create a dataset.
To add charts for data visualization and analysis, see Create a dashboard and Overview of charts.
To drill down for in-depth data analysis, see Step 3: Configure and display drilling settings.