copy_data
Insert data into a Vertica database table using the COPY command. Specify schema, table name, and data rows to perform bulk data operations with connection security and progress reporting.
Instructions
Copy data into a Vertica table using COPY command.
Args:
ctx: FastMCP context for progress reporting and logging
schema: vertica schema to execute the copy against
table: Target table name
data: List of rows to insert
Returns:
Status message indicating success or failure
Input Schema
Name | Required | Description | Default |
---|---|---|---|
data | Yes | ||
schema | Yes | ||
table | Yes |
Input Schema (JSON Schema)
{
"properties": {
"data": {
"items": {
"items": {},
"type": "array"
},
"title": "Data",
"type": "array"
},
"schema": {
"title": "Schema",
"type": "string"
},
"table": {
"title": "Table",
"type": "string"
}
},
"required": [
"schema",
"table",
"data"
],
"title": "copy_dataArguments",
"type": "object"
}