Data Generator (Not Promoted)

Procedure

1. Click in the upper left corner and select a region and project.
2. Click in the upper left corner, and under Databases, click Data Admin Service.
3. In the navigation pane on the left, choose Development Tool.
4. Locate the DB instance that you want to log in to and click Log In in the Operation column.
5. On the top menu bar, choose Data Scheme > Data Generator.
6. On the displayed page, click Create Task.
7. In the displayed dialog box, configure required 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.

8. Click Preview to check whether the data that will be generated can meet your requirements. If not, adjust the generation rules.
9. Click Generate.
10. In the task list, locate the created task and click Details.

    You can also delete the task as required.