Create Table
create-tableCreates an empty RawTree table in a database, with optional sorting key, TTL retention, and engine settings, so you can start storing and querying structured data.
Instructions
Purpose: Create an empty RawTree table in a database.
Returns: The database and table names, resolved storage destination, sorting_key, ttl (stored expression or null), and settings (explicit {name, value} entries with SQL values and secrets masked by the engine).
Behavior: The table uses the database's storage when the database configures one, and the cluster's default storage otherwise. Storage is configured on the cluster or the database, never per table.
Sorting key: sortingKey is an optional string of comma-separated SQL expressions. Omit it and the table picks a sorting key per part from the ingested data, which suits exploratory tables. Set it when the query pattern is known, listing expressions in key order, lowest cardinality first. Use update-table to change it later.
Configuration: Optional ttl sets row-deletion retention; settings supplies engine settings as string, number, or boolean literals.
Auth: Requires organization admin access. Authorization is enforced by the RawTree API.
Reliability: If the response is ambiguous, call list-tables to reconcile by database and table name before retrying.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"name": "<name>"
},
"name": "create-table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ttl | No | Row-deletion TTL SQL expression, optionally followed by DELETE WHERE <condition>. Subqueries and other TTL actions are unsupported. Omit to leave unchanged on update; null and empty strings cannot remove TTL. | |
| name | Yes | Name of the table to create. | |
| cluster | No | RawTree cluster to use for this operation. | |
| database | No | Optional RawTree database override. RawTree uses the default database when omitted. | |
| settings | No | Engine settings as JSON scalar values. Strings are literal values, not SQL expressions. Updates change supplied settings only; omitted settings are preserved. This route cannot reset settings. | |
| sortingKey | No | Optional comma-separated SQL sorting expressions in key order. Omit it to let the table pick a key per part from the ingested data. | |
| organization | No | RawTree organization containing the target cluster. |