generate_synthetic_data
Create and insert synthetic data into a specified table, supporting custom column generators and batch processing for efficient data population in SingleStore databases.
Instructions
Generate and insert synthetic data into an existing table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| batch_size | No | Number of rows to insert in each batch | |
| column_generators | No | Custom generators for specific columns (optional) | |
| count | No | Number of rows to generate and insert | |
| table | Yes | Name of the table to insert data into |
Input Schema (JSON Schema)
{
"properties": {
"batch_size": {
"default": 1000,
"description": "Number of rows to insert in each batch",
"type": "number"
},
"column_generators": {
"additionalProperties": {
"properties": {
"end": {
"description": "Ending value for random number generator",
"type": "number"
},
"formula": {
"description": "SQL expression for formula generator",
"type": "string"
},
"start": {
"description": "Starting value for sequence generator",
"type": "number"
},
"type": {
"description": "Type of generator to use",
"enum": [
"sequence",
"random",
"values",
"formula"
],
"type": "string"
},
"values": {
"description": "Array of values to choose from for values generator",
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"description": "Custom generators for specific columns (optional)",
"type": "object"
},
"count": {
"default": 100,
"description": "Number of rows to generate and insert",
"type": "number"
},
"table": {
"description": "Name of the table to insert data into",
"type": "string"
}
},
"required": [
"table"
],
"type": "object"
}