Insert JSON
insert-jsonInsert one JSON object or an array of JSON objects into a RawTree table, which auto-creates the table on first insert.
Instructions
Purpose: Insert one JSON object or an array of JSON objects into a RawTree table. RawTree auto-creates the table on first insert.
NOT for: Loading data from a public URL (use insert-from-url). Not for transformed URL ingest; transforms only apply to JSON request bodies.
Returns: Insert confirmation, usually { "inserted": }. Firehose transform returns request metadata.
When to use:
User wants to send events, logs, traces, metrics, or arbitrary records to RawTree
You need to create a table by inserting the first row
You need to validate that RawTree accepts a payload shape
You have OTLP, CloudWatch Logs, CloudTrail, or Firehose JSON that should be flattened by RawTree
Workflow: Choose a table name → send a small representative payload → run describe-table or run-query to verify.
Key trigger phrases: "insert this", "send event", "write to RawTree", "create table with data", "ingest JSON"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Target table name. RawTree accepts identifiers like events, traces, api_logs. | |
| data | Yes | A JSON object or a non-empty array of JSON objects to insert. | |
| transform | No | Optional RawTree built-in transform for JSON body inserts: otlp-traces, otlp-logs, otlp-metrics, cloudwatch-logs, cloudtrail, or firehose. | |
| columns | No | For transform=firehose only: TSV column names matching each Firehose record line. |