Quick BI:Add an RDS MySQL DuckDB Data Source

Prerequisites

You have created a DuckDB analysis instance. For more information, see DuckDB analysis instance.

Procedure

1. Add IP addresses to the whitelist.

   Before connecting to your Alibaba Cloud RDS MySQL DuckDB database over the public network, you must add Quick BI's IP addresses to the database whitelist. For instructions, see Set a whitelist.

2. Log on to the Quick BI console.

3. Navigate to the data source creation page. For more information, see Create a data source.

4. On the Alibaba Cloud Databases tab, select the RDS MySQL DuckDB data source.

   

5. In the connection configuration dialog box, configure the following parameters.

   Parameter	Description
   display name	The name displayed in the data source list. Enter a descriptive name that does not contain special characters or leading or trailing spaces.
   database address	The public address of your MySQL DuckDB database. If you use a VPC data source, enter the internal address of the database. To obtain the database address, log on to the RDS management console. On the Basic Information page, click View Connection Details. An example address is rm-xxxxxxxxxxxxxxxxxx.mysql.rds.aliyuncs.com.
   port	The database port number. Default: 3306. If you use a VPC data source, enter the internal port of the database.
   Database	The name of the database to connect to.
   username and password	The username and password for the database account. Ensure that this account has CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
   Database Version	Select the version of your database. Select 5.7 for MySQL 5.7 or earlier. Select 8.0 for MySQL 8.0.
   VPC data source	To connect through an Alibaba Cloud VPC, select VPC data source and configure the following parameters: AccessKey ID and AccessKey Secret: The AccessKey ID and AccessKey Secret of an account with access to the target MySQL DuckDB database. The account must have read permissions on the target instance. If the account also has write permissions, Quick BI automatically adds its IP addresses to the whitelist. Otherwise, add them manually. For more information about how to create a custom policy, see Create a custom policy. You can obtain the AccessKey ID and AccessKey Secret from the RAM console. instance ID and region: The instance ID of the MySQL DuckDB database and the region where it is located. You can obtain this information from the RDS management console. Note If you select VPC data source, you must enter the internal address and internal port for the database address and port fields, respectively.
   SSL	Select SSL to encrypt data in transit if the data source has SSL configured.
   initialization SQL	Specify SQL statements to run immediately after connecting to the data source. Only SET statements are allowed. Separate multiple statements with semicolons (;).
   Enable file upload entry	When enabled, you can upload local files to this database.

6. Click Test Connection to verify the connection.

   

7. After the connection test is successful, click OK to add the data source.

Next steps

After creating the data source, create a dataset to start analyzing your data.

• Add tables from your RDS MySQL DuckDB database or create custom SQL queries to build a dataset. For more information, see Create a dataset.

• Create dashboards and charts to visualize and analyze your data. For more information, see Create a dashboard and Chart overview.

• Use the drill-through feature for in-depth data analysis. For more information, see Configure and use drill-through.