Skip to content

Latest commit

 

History

History
40 lines (27 loc) · 1.32 KB

external-table-mapping-create.md

File metadata and controls

40 lines (27 loc) · 1.32 KB
Raw
title description ms.topic ms.date
.create external table mapping command
Learn how to use the `.create external table mapping` command to create an external table mapping for Azure Blob Storage or Azure Data Lake external tables.
reference
05/24/2023

.create external table mapping command

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

Syntax

.create external table ExternalTableName mapping MappingName MappingInJsonFormat

[!INCLUDE syntax-conventions-note]

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