.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
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"}}] |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for