Edit

.create external table mapping command

  • Article

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"}}]