.create-merge table

Add declared columns to a table, or create the table if it does not exist. Existing inferred columns and retention settings are preserved. Additional columns continue to be inferred during ingestion.

This command has the same permissions and column syntax as .create table.

Spec

.create-merge table '<table_name>' (<column_name>:<type>, ...)

Parameters

• table_name: Table name within the current account.
• column_name: Unique, unquoted column identifier; at least one declaration is required.
• type: Supported declared type, as listed in .create table.

An existing inferred column becomes declared when its stored type matches. Repeating a matching declaration is safe. Conflicting types are rejected; existing data is not converted and columns are not removed.

Example

.create-merge table 'logs' (attachment:BlobReference, requestId:Int128)