5.2.4 Running JSON Blueprints

Quickly run a blueprint on the Data Generator home page or generate data in Blueprint Designer.

• Selecting Data Generation Schema
  On the Data Generator home page, click the drop-down list under Data Generation Schema to select the database schema to be used for data generation. The Data Generator home page reloads.
• Generating Data from a Blueprint
  Click the corresponding Generate Data button for the blueprint you want to populate with sample data. For valid tables, you can generate an exportable file or insert the data into corresponding tables in the workspace.

5.2.4.1 Selecting Data Generation Schema

On the Data Generator home page, click the drop-down list under Data Generation Schema to select the database schema to be used for data generation. The Data Generator home page reloads.

The Data Generator home page only shows blueprints created for a specific schema. If you change the schema, the list of available blueprints also changes.

5.2.4.2 Generating Data from a Blueprint

Click the corresponding Generate Data button for the blueprint you want to populate with sample data. For valid tables, you can generate an exportable file or insert the data into corresponding tables in the workspace.

Note:

The Insert Into Database option overwrites existing data.

1. Do one of the following:
   • On the Data Generator home page, click Generate Data for the chosen blueprint.
   • Open a blueprint in Blueprint Designer and click Generate Data.
   The Generate Blueprint Data dialog displays.
2. For Action, select one of the following:
   • 1. File Export - Generates an object to download onto your local system.
     2. Output Format - Choose whether to export a JSON, CSV, or SQL file.

        Note:

        For CSV, if there is only one table in the blueprint, this process generates one CSV file. If multiple tables exists, this process generates one ZIP file containing one CSV file per table inside.

     3. (Optional) Row Scaling - (Default 1x) Change this value to change the amount of generated data. For example, .25x generates a quarter of the provided rows; 100x generates one hundred times the number of provided rows.
     4. Click Generate Data.
   • 1. Insert Into Database - Inserts all generated data into matching tables in the schema.

        Note:

        The Insert Into Database option overwrites existing data. Ensure you know table constraints and triggers that may prevent successful insert operations before inserting.
     2. Insert Method - Insert Into inserts one row at a time (if there are errors on this action, the row is discarded and the next insert attempts to run). Fast Insert Into inserts all rows at once (if the insert fails on a table, adds no records).
     3. (Optional) Row Scaling - (Default 1x) Change this value to change the amount of generated data. For example, .25x generates a quarter of the provided rows; 100x generates one hundred times the number of provided rows.
     4. Click Insert Data.