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