Data Generator (Not Promoted)

Procedure

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane on the left, choose Development Tool.

   You can also click Go to Development Tool on the overview page.

5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
6. On the top menu bar, choose Data Scheme > Data Generator.
7. On the displayed page, click Create Task.
   Figure 1 Creating a data generation task
   

8. In the displayed dialog box, configure required parameters.
   Figure 2 Configuring task parameters
   
   • Rows to Generate

     A maximum of 1,000,000 rows of data can be generated.

   • Conflict Policy

     If you select Skip, the system skips data rows in conflict and continues generating data. If you select Replace, the system replaces existing rows with new ones that have the same primary key.

   • Generation Mode

     On the Create Task page, double-click one column you want to select. Set rules for generating data randomly based on the column information. For example, if the column name is time, you need to specify start and end time and the generation format. Alternatively, select Based on current time.

9. Click Preview to check whether the data that will be generated can meet your requirements. If not, adjust the generation rules.
   Figure 3 Data preview
   

10. Click Generate.
    Figure 4 Test data generation progress
    

11. In the task list, locate the created task and click Details.
    You can also delete the task as required.

    Figure 5 Task list