Loading Data to Read-Only Analysis Engine
Last updated:2026-01-12 17:16:53
This document introduces how to load data into the read-only analysis engine for data analysis and querying.
Note:
Currently, only databases, tables, and views are supported for loading into the read-only analysis engine.
Prerequisites
You have prepared a TencentDB for MySQL instance. See Creating a MySQL Instance.
The instance is running.
Directions
The read-only analysis engine currently supports multiple methods for data loading. The detailed procedures are as follows.
Method 1: Loading Data When Creating the Read-Only Analysis Engine
When creating a read-only analysis engine instance, you can choose the data loading method. Currently, three options are supported: all objects, partial objects, and no object. Each option corresponds to a different data loading scheme.
1. The data loading method is all objects.
In all objects mode, all databases and tables in the TencentDB for MySQL instance are automatically synchronized to the read-only analysis engine. If certain objects do not meet the loading requirements, they will be automatically ignored and will not be loaded into the engine.
2. The data loading method is partial objects.
If partial objects is selected as the data loading method, you need to specify the objects to be loaded into the analysis engine when creating the read-only analysis engine instance. Any objects that do not meet the loading requirements will be ignored. If a view references a table that has not been loaded into the engine, an error will be reported during the view loading process indicating that the table does not exist.
3. The data loading method is no object.
If no object is selected as the data loading method, no objects will be loaded when you create the read-only analysis engine instance. You will need to manually specify the objects to be loaded during instance operation. See Method 2: Manual Loading.
Method 2: Manual Loading
If you selected no object when creating the read-only analysis engine instance, or if you need to modify the objects loaded into the engine, you can use the following method.
Loading Objects via the Console
1. Log in to MySQL console. In the instance list, click Instance ID or manage in the operation column to enter the instance detail page.
2. Under the instance architecture diagram, locate the read-only analysis engine instance and click Instance ID to enter the details page of the read-only analysis engine.
3. Click Modify Objects. In the Modify Objects dialog box, Select or cancel the objects you want to load into the read-only analysis engine.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback