.create-merge tables command

Lets you create and extend the schemas of existing tables in a single bulk operation, 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 tables tableName1 (columnName:columnType [, ...]) [, tableName2 (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

• Specified tables that don't exist will be created.
• Specified tables that already exist will have their schemas extended.
  • Nonexistent columns are added at the end of the existing table's schema.
  • Existing columns that aren't specified in the command won't be removed from the existing table's schema.
  • Existing columns that are specified with a data type in the command that is different from the one in the existing table's schemas lead to a failure. No tables are created.

Example

.create-merge tables 
  MyLogs (Level:string, Timestamp:datetime, UserId:string, TraceId:string, Message:string, ProcessId:int32),
  MyUsers (UserId:string, Name:string)

Output

tableName	DatabaseName	Folder	DocString
MyLogs	TopComparison
MyUsers	TopComparison