.create external table mapping command

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

Create a new external table data mapping. For more information, see Data mappings.

Syntax

.create external table ExternalTableName mapping MappingName MappingInJsonFormat

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
ExternalTableName	The name of the external table to which to assign the mapping.
MappingName	The name of the mapping.
MappingInJsonFormat	The mapping definition in JSON format.

Returns

Returns a table containing the new mapping name, mapping kind, and mapping definition.

Example

.create external table MyExternalTable mapping "Mapping1" '[{"Column": "rownumber", "Properties": {"Path": "$.rownumber"}}, {"Column": "rowguid", "Properties": {"Path": "$.rowguid"}}]'

Output

Name	Kind	Mapping
mapping1	JSON	[{"ColumnName":"rownumber","Properties":{"Path":"$.rownumber"}},{"ColumnName":"rowguid","Properties":{"Path":"$.rowguid"}}]