.create-merge table command

Applies to: ✅ Azure Data Explorer

Creates a new table or extends an existing table.

The command must run in the context of a specific database.

Permissions

This command requires Database User permissions, and Table Admin permissions for extending existing tables.

.create-merge table tableName (columnName:columnType [, ...]) [with (propertyName = propertyValue [, ...])]

Name	Type	Required	Description
tableName	`string`	✔️	The name of the table to create or extend.
columnName, columnType	`string`	✔️	The name of an existing or new column mapped to the type of data in that column. The list of mappings defines the output column schema.
propertyName, propertyValue	`string`		A comma-separated list of key-value property pairs. See supported properties.

Name	Type	Description
`docstring`	`string`	Free text describing the entity to be added. This string is presented in various UX settings next to the entity names.
`folder`	`string`	The name of the folder to add to the table.

If the table doesn't exist, functions exactly as .create table command.

If table T exists, and you send a .create-merge table T (<columns specification>) command, then:

Any column in <columns specification> that didn't previously exist in T will be added to the end of T's schema.
Any column in T that isn't in <columns specification> won't be removed from T.
Any column in <columns specification> that exists in T, but with a different data type will cause the command to fail.