Aqua Data Studio lets you create or build test data for your application or database. You can now create random tables without any data, random tables with random data, or populate random data into existing tables. This feature facilitates various tests without compromising sensitive information.
The Random Table and Data Generator feature can be accessed in several ways:
- Via Tools menu: In the main menu bar, select Tools > Random Table and Data Generator.
- Via connection context menu: In the schema tree, right-click on a connection object and select Tools > Random Table and Data Generator.
- Via table object context menu: In the schema tree, select one or more table objects and right-click on a selected table object, and select Tools > Random Table and Data Generator.
Launching the Random Table and Data Generator from Tools Menu
In the main menu bar, select Tools > Random Table and Data Generator
This first shows the database server selection window.
Select a database connection, then click OK. A new Random Table and Data Generator tab will be displayed with the selected database connection.
Launching the Random Table and Data Generator from a Database Connection
In the schema tree, right-click on a connection object and select Tools > Random Table and Data Generator.
A new Random Table and Data Generator tab displays with the selected database connection.
Launching the Random Table and Data Generator from Table Objects
In the schema tree, select one or more table objects and right-click on a selected table object, and select Tools > Random Table and Data Generator.
A new Random Table and Data Generator tab will be displayed with the selected database connection. The list of Existing Tables will be pre-populated with the selected tables.
Random Table and Data Generator
Check the Generate Random Table checkbox to generate random tables. You can also decide whether or not to generate random data for the newly generated tables by checking or unchecking the Generate Data for New Tables checkbox.
- Table Prefix: Specify a prefix for the random table names. This helps identify the newly generated tables.
- Minimum Tables: Sets the minimum number of tables to be generated.
- Maximum Tables: Sets the maximum number of tables to be generated. The number of generated random tables will be somewhere in between Minimum Tables and Maximum Tables. The limit for maximum tables: 10,000
- Column Prefix: Specify a prefix for the column names for the random tables.
- Minimum Columns: Sets the minimum number of columns to be generated.
- Maximum Columns: Sets the maximum number of columns to be generated. The number of generated columns for each random table will be somewhere in between Minimum Columns and Maximum Columns. The limit for maximum columns: 1000
Generate Random Data in Existing Tables
You can also generate random data into existing tables. You can opt to do only this or in addition to generating the random tables. Click the Add/Remove Tables button to edit the list of existing tables.
When generating random data in existing tables it is possible to get an 'Ignore table <table name>' line in the status section, this happens because the table contains unsupported or null-knowable datatypes.
For Hive databases, the MapReduce engine might be required to do table inserts when generating data.
Data Options
There is an option to allow adding Timestamps to the data and table generation. Here you can also specify the minimum and a maximum number of rows. The limit for maximum rows is 10,00,000
Finally, you can decide to Generate it to a database or to a file. The first selection generates the tables and data inside the database/schema specified in the Database Connection section.
If you choose to Generate it to a file, a file selection dialog box will be shown in which you need to select an empty folder where the generated files will be stored. You can also create a new folder in this dialog box. A DDL file will be generated for the random table creation and a separate file will be generated for the population of each table with random data.
Clicking the Close button will close the Random Table and Data Generator UI without any changes applied to your database.