.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.
Syntax
.create-merge table tableName (columnName:columnType [, ...]) [with (propertyName = propertyValue [, ...])]
Learn more about syntax conventions.
Parameters
| 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. |
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. |
Returns
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.